[dba-SQLServer] Finding current user role

David Emerson davide at dalyn.co.nz
Thu Jun 3 21:49:09 CDT 2004


SQL2000  AXP ade

I am using Windows NT Integrated security.  The users will be members of NT 
Groups (specifically set up for the SQL databases), and the NT Groups will 
be members of SQL Roles.  SQL permissions are then applied to the roles.

However, within the ade I would like to know what role the current user 
belongs to so I can make the form changes.  Is there a system command that 
will give me this info?

Regards

David Emerson
Dalyn Software Ltd
25 Cunliffe St, Churton Park
Wellington, New Zealand
Ph/Fax (04) 478-7456
Mobile 027-280-9348 




More information about the dba-SQLServer mailing list