.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Fixed database role for managing db objects.

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :

I need to allow a user to

Edit schemas, objects and data.

Can I use one of fixed database roles?

View Complete Post

More Related Resource Links

Toolbox: Static Analysis Database Tools, Managing Remote Computers, And More


If you want to apply static analysis to your databases, connect to remote computers, find out more about the Entity Framework, or just check into some cool podcasts for your daily commute, then you'll want to read more about these latest tools and resources.

Scott Mitchell

MSDN Magazine July 2009

Test-Driven Design: Using Mocks And Tests To Design Role-Based Objects


Use Test-Driven Development with mock objects to design object oriented code in terms of roles and responsibilities, not categorization of objects into class hierarchies.

Isaiah Perumalla

MSDN Magazine June 2009

Remoting: Managing the Lifetime of Remote .NET Objects with Leasing and Sponsorship


Leasing and sponsorship is the solution for managing the lifecycle of a remote object in .NET. Each object has a lease that prevents the local garbage collector from destroying it, and most distributed applications rely upon leasing. There are several ways in which objects and clients can extend the lease, including dedicated sponsor objects. In this article, the author explains leasing, shows how to configure it, and how it relates to the various remoting activation models. He then discusses design guidelines and options, along with their impact on throughput and performance. Additionally, he introduces a helper class used to automate the management of lease sponsors.

Juval Lowy

MSDN Magazine December 2003

Managing the FTP server with Sql database

Hi I have an FTP server that want to give access rights to the users who are all in a sqp database and future users will signup to the same database. How can I make the FTP security to look at this database and get the usernames and passwords from it?

Database diagram support objects cannot be installed...

I can't make a diagram on our server(Win2003 x64,SQL 2005 Enterprise x64 sp2 3054). I have tried to login as an admin and create a new db, but get the same message - 'Database diagram support objects cannot be installed because this database does not have a valid owner. To..' Also tried to make a diagram from the ReportServer db.   Any suggestions?

user mapping to a database and role membership to that database

When assigning a 'user mapped Login' to a database and role membership to that database, is it redundent to check/enable db_datareader, db_datawriter as well as db_owner or will check/enable db_owner become all that is necessary to provide role membership to the database?

xp_cmdshell not executing for fixed server role.

Hi all, i hope you can help me. i am logon into sql server 2005 using my windows account. i am trying to execute xp_cmdshell from my account as i am member of fixed server role (sysadmin acouunt). when i am executing xp_cmdshell , its running under ##xp_cmdshell_proxy_account## "Proxy acoount".  please help me to run under sysadmin account .

Managing TypedDataSets when there is a change in backend Table / Stored Procedure / Database schema

Hi All, I am just curious to know if there is any easier way to synchronize the TypedDataSets with the chages made to backend Table / Stored Procedure schema.  I use Typed DataSets in my project extensively and I found them very useful and easier to code, but difficult to maintain  The difficuly I have always faced is whenever there is a change in a backend database table structure or stored procedure that is linked to any of the Typed DataSet in our project requires to recreate whole DataSet again by scrapping the old one. The backend changes will not be reflected unless and untill you recreate the whole stuff again. Is there any easier way to synchronize those typed datasets with the changes made to backend database schema or any other workaround that will not required to recreate the whole DataSet again.Hope above question makes sense. Any ideas.

Same Role provider (ASP.NET Services database) for various WCF services


Hi there,

Service Authetnication

Have configured WCF service to implement authentication using AD(Active Directory), when a request comes from the client it is authenticated aginst active directory and either allow access or deny based on the credentials passed to the service.

Authorization using ASP.NET Role provider

Have implemented the method level authorization using SecurityPermission attribute, which checks the role data in ASP.NET Services database( in other words Membership database) against aspnet_roles, aspnet_Users_InRoles tables to allow / deny access to particular method.

It works well with single instance of service, where the request is from mutliple client applicaitons.

In the above implementation, WCF service is configured to use ASP.NET Membership database to implement authorization to authorize access to particular methods.


Would like to know if it is feasible/best practice to utilise the same instance of ASP.NET Membership databse to implement Role based authorization on number of WCF services.

[PrincipalPermission(SecurityAction.Demand, Role = <

Migrating ASPNET Role/Membership Database to New Server



I have an existing ASPNET role/membership database created on SQLExpress 2005 (WIndows 2003 Server). I created it under the .NET 3 framework many years ago using the aspnet_regsql.exe application in full GUI mode. 

I am setting up a new Windows 2008R2 server with .Net Framework 4 and SQL Server 2008R2. I don't want users to have to recreate accounts or create roles, etc.


1. Should I backup the current database and import it into the new system, and if so do I even need to use the aspnet_regsql.exe application. (If so which version do I use, different aspnet_regsql.exe files exist in different directories (i.e., FrameWork, FrameWork64)

2. Should I just run aspnet_regsql.exe on its own and then somehow try to import the current data into those tables.

I am concerned that if I just import somehow the roles within SQL server will not be created properly. 

thanks in advance,


checking for database objects that don't compile


It has always struck me that SQL server doesnt have a way in which I can run automated tests or checks on the database to weed out objects that no longer work/compile/execute. As we all know, sometimes database schema changes frequently i.e a column rename is a classical example and some stored procedures/functions which may be legacy then no longer works, in my situation a legacy application was re-written, but it was difficult picking up the objects specific to that application, so as the schema has changed, some procs and functions no longer work, but such objects are no longer required to be on the DB, but we want to pick out the ones that no longer compiles and remove appopriately.

Any ideas ?

Find unused objects in a SQL Server 2000 database


Hello All,

I want to know all the objects in a database which are not been used from a long period (Unused in the sense not executed from a long period; example procedures.). Could anyone show be the way of how to get it done.

Thanks in advance.

Pavan Kokkula Infosys Technologies Limited.

How many database access objects should I use?


Hi everyone. I'd like to know if I'm doing wrong about performance/optimization. Let me explain:

Among my classes there is one (lets call it db_SqlServer) that is used to query the database using stored procedures. Every other class in the site that needs to access the database has an object of that db_SqlServer class. So when they query the database, the class db_SqlServer opens a connection, returns the results and closes the connection.

In short, I can have several db_SqlServer objects depending on how many other classes are running at that moment.

What should I do? Just one static db_SqlServer class? Use singleton to create just one instance of the class? I mean, is bad for performance to give every class its own db_SqlServer object or not? Is good for speed?

Many thanks in advance.

SSIS Database Transfer Error - "Role Exists" even though DB is being overwritten in task.



Can't get over this error, and net searches reveal other postings similiar, but no answers.

SSIS database transfer task (with overwrite) from SQL 2k source to SQL 2k5 destination fails with:


Error: The Execute method on the task returned error code 0x80131500 (ERROR : errorCode=-1073548784 description=Executing the query "CREATE ROLE [RFRSH_USER] " failed with the following error: "User, group, or role 'RFRSH_USER' already exists in the current database.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.  helpFile= helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}). The Execute method must succeed, and indicate the result using an "out" parameter.

The error seems the same regardless if the destination DB exists or not!

Anyone have a solution?




Managing user accounts in SQL database for form based authentication


Hi everyone

I have just configured form based authentication using a SQL database created using aspnet_regsql.exe.
Does anyone know of an good solutions that my customer can use to manage it, add users, delete user etc


delete all the objects from a database


How can I delete all the objects from a database? (tables, stored procedures, etc.).


Thank you!


Restored database with ASPNET Role data and no one can login now


I have an application that uses the ASPNET role provider.  My SQL Server crashed so I took a backup of the database and restored it to a new SQL Server and changed the db connection string to that server.  The web site runs but no users can login to the site.  Is there something that I should have done when the db was on the other server?

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend