Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag db_owner Rss

   Items 1 to 3 of 3   
 

Blocking SQL Server db_datareader, db_datawriter, and db_owner Permissions

n a database I currently support, the application makes use of db_datareader and db_datawriter to give permissions to the tables. In a different database, it's even worse as the application uses db_owner. We're adding new tables to both databases and we don't want the application to have access to these tables. How can I deal with the use of these three roles?  Read more...
By Additional Articles 2013/04/02 | Source: MSSQLTips.com | Category: db_datareader
Rating: (not yet rated)  Rate this |   Briefcase | 3,318 reads

The Power of the SQL Server Database Owner

I have a couple of databases supporting applications. The first application requires that it's user be a member of the db_owner role. The second application actually has to own the database. What are the effects of having such permissions? Check out this tip to learn more.  Read more...
By Additional Articles 2013/03/20 | Source: MSSQLTips.com | Category: db_owner
Rating:  Rate this |   Briefcase | 3,869 reads

Change all of your database owners

globally change all the database owners on a server.  Read more...
By @STLSQLGuy 2010/09/08 | Source: SQLServerCentral.com | Category: sp_msforeachdb
Rating: |  Discuss |   Briefcase | 2,086 reads
   Items 1 to 3 of 3   
 
Tags
db_datareader (1)    
db_datawriter (1)    
sp_changedbowner (1)    
sp_msforeachdb (1)