[dba-SQLServer] Finding current user role

David Emerson davide at dalyn.co.nz
Thu Jun 3 23:18:30 CDT 2004


Thanks Stuart (and Chris)

David

At 4/06/2004, you wrote:
>On 4 Jun 2004 at 14:49, David Emerson wrote:
>
> > 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?
> >
>
>
>Take a look at sp_helpuser and current_user
>
>
>--
>Lexacorp Ltd
>http://www.lexacorp.com.pg
>Information Technology Consultancy, Software Development,System Support.
>
>
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com




More information about the dba-SQLServer mailing list