Re: Users Role
- From: Sue Hoegemeier <Sue_H@xxxxxxxxxxxxx>
- Date: Tue, 17 Jan 2006 17:02:17 -0700
Maybe you are looking for the IS_MEMBER function. You can
use that to find out if the current user is a member of
whatever database role you pass to the function.
-Sue
On Tue, 17 Jan 2006 16:51:20 -0500, "Rogers"
<naissani@xxxxxxxxxxx> wrote:
>Thanks but I need one query through which I can findout that becauase I am
>creating a cursor and at the runtime I will set the rolname into
>variable....
>
>Thanks
>"samsøe" <samse@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>news:3BB59877-FADB-4BDB-B3C1-ADEB08A57E5F@xxxxxxxxxxxxxxxx
>>
>>
>> "Rogers" wrote:
>>
>>> I want to findout the users and its role in specific database like that
>>> user
>>> has db_owner rights, I want one query that I can execute in the Query
>>> Analyzer and findout the role.
>>>
>>> Thanks
>>>
>>>
>>>
>> SQL 2000:
>> try
>> exec sp_helpuser or altrenatively
>> exec sp_helpuser <username>
>>
>> change the database context to the relevant database
>
.
- References:
- Users Role
- From: Rogers
- Re: Users Role
- From: Rogers
- Users Role
- Prev by Date: Re: Users Role
- Next by Date: REmote Debugging from Visual Std. 2003 env
- Previous by thread: Re: Users Role
- Next by thread: REmote Debugging from Visual Std. 2003 env
- Index(es):
Relevant Pages
|
