Determining Database Role Membership 
Author Message
 Determining Database Role Membership
In T-SQL, how can I determine if a user is a member of a specific database
Role?

I need a solution that works in both SS7 and SS2000

Thanks in advance!



Fri, 12 Aug 2005 15:16:38 GMT
 Determining Database Role Membership

Have a look at IS_MEMBER in BOL.

--
HTH

Jasper Smith (SQL Server MVP)

I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org


Quote:
> In T-SQL, how can I determine if a user is a member of a specific database
> Role?

> I need a solution that works in both SS7 and SS2000

> Thanks in advance!



Fri, 12 Aug 2005 15:41:42 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Determining Role membership from System_User

2. Determining Membership in Role Chains

3. Database role membership for replication

4. determining database membership

5. Membership of a User in a Role

6. Membership of a user in a role

7. Reading membership of all roles for a user

8. Minimal membership of fixed server roles

9. Checking role memberships programmatically

10. Determine Security Group Membership

11. Database Role vs Cube Role

12. Server Roles/Database Roles


 
Powered by phpBB® Forum Software