Monday, May 10, 2010

Find User Or Login That Has The DB Owner Role In Any Database

Find user Or Login that has the DB Owner Role In Any Database.

If you want you can replace the 'db_owner' with other fixed database roles such as db_accessadmin, db_backupoperator, db_datareader, db_datawriter, db_ddladmin, db_denydatareader, db_denydatawriter and db_securityadmin using the below instruction:

Here is the script to find db_owner access users:
 
select user_name(member_principal_id) from sys.database_role_members where role_principal_id = user_id('db_owner')
orphaned login details in sql server. sql server login migration script. login migration script. login move move details. users migration script. user move script in sql server 2012. in sql server 2008 r2. in sql server 2008. login move. server login migration. server login move from sql 2005 to sql 2012. sql login with encrypted password. easy script for login movement. login script. find db-owner users in a server, find all db owner access in the server, database owner access in sql server 2012, database owner access in sql server 2008, database owner access in 2005.

0 comments:

Post a Comment