Chris Mackin
chris at denverdb.com
Thu Jun 3 23:04:07 CDT 2004
Look in BOL at "sp_helprolemember", I use that to find what roles each user is in. -Chris Mackin -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of David Emerson Sent: Thursday, June 03, 2004 8:49 PM To: dba-SQLServer at databaseadvisors.com Subject: [dba-SQLServer] Finding current user role 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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com