Permissions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

moharil - 23 Aug 2007 13:50 GMT

Hi ,

I need to find out which are the System generated list of accounts and what
all permissions are granted to these login in the PROD DB .

Also what roles are assigned to which accounts

Regards

-SQL newbie

Reply to this Message

moharil - 23 Aug 2007 15:24 GMT

i think this should help right is there anything else that we can do ?

sp_helprolemember and sp_helpsrvrolemember

Signature

-SQL Nebie

> Hi ,
>
[quoted text clipped - 6 lines]
>
> -SQL newbie

Reply to this Message

Russell Fields - 24 Aug 2007 16:39 GMT

sp_helprotect will also let you find rights directly assigned to a user that
were not assigned through a role. It can also be used to enumerate the
object rights granted to a role.

(Are you on SQL Server 2000?)

RLF

>i think this should help right is there anything else that we can do ?
>
[quoted text clipped - 10 lines]
>>
>> -SQL newbie

Reply to this Message