Monday, March 12, 2012

Permissions and privileges

Hi
I would like to have a list of all those who have access to my
databases and what privileges they have.
If any one has something in the same lines that could be shared it
will be very much appreciated
VinceMost of the web sites have scripts for this. SQL Server
Central has several - these are links to some of the
scripts:
http://www.sqlservercentral.com/scripts/contributions/263.asp
http://www.sqlservercentral.com/scripts/contributions/573.asp
http://www.sqlservercentral.com/scripts/contributions/268.asp
-Sue
On 4 Sep 2003 10:44:02 -0700, wumutek@.yahoo.com (Vincento
Harris) wrote:
>Hi
>I would like to have a list of all those who have access to my
>databases and what privileges they have.
>If any one has something in the same lines that could be shared it
>will be very much appreciated
>
>Vince|||Sue Hoegemeier <Sue_H@.nomail.please> wrote in message news:<jkjhlv0bidmj1okqgelfjijbks41sgc0et@.4ax.com>...
> Most of the web sites have scripts for this. SQL Server
> Central has several - these are links to some of the
> scripts:
> http://www.sqlservercentral.com/scripts/contributions/263.asp
> http://www.sqlservercentral.com/scripts/contributions/573.asp
> http://www.sqlservercentral.com/scripts/contributions/268.asp
> -Sue
> On 4 Sep 2003 10:44:02 -0700, wumutek@.yahoo.com (Vincento
> Harris) wrote:
> >Hi
> >I would like to have a list of all those who have access to my
> >databases and what privileges they have.
> >If any one has something in the same lines that could be shared it
> >will be very much appreciated
> >
> >
> >Vince
Thanks Sue now I know the sp_helprotect procedure is out there.
The script did not seem to give the information I needed.
I will still be interested in a script that lists ALL users and the
permissions they have in the database.
Will greatly appreciate your expert directions
Vincentos|||Use the example in the first link:
http://www.sqlservercentral.com/scripts/contributions/263.asp
and don't pass in a user name. It will go through all the
users in the database.
-Sue
On 8 Sep 2003 11:29:56 -0700, wumutek@.yahoo.com (Vincento
Harris) wrote:
>Sue Hoegemeier <Sue_H@.nomail.please> wrote in message news:<jkjhlv0bidmj1okqgelfjijbks41sgc0et@.4ax.com>...
>> Most of the web sites have scripts for this. SQL Server
>> Central has several - these are links to some of the
>> scripts:
>> http://www.sqlservercentral.com/scripts/contributions/263.asp
>> http://www.sqlservercentral.com/scripts/contributions/573.asp
>> http://www.sqlservercentral.com/scripts/contributions/268.asp
>> -Sue
>> On 4 Sep 2003 10:44:02 -0700, wumutek@.yahoo.com (Vincento
>> Harris) wrote:
>> >Hi
>> >I would like to have a list of all those who have access to my
>> >databases and what privileges they have.
>> >If any one has something in the same lines that could be shared it
>> >will be very much appreciated
>> >
>> >
>> >Vince
>Thanks Sue now I know the sp_helprotect procedure is out there.
>The script did not seem to give the information I needed.
>I will still be interested in a script that lists ALL users and the
>permissions they have in the database.
>Will greatly appreciate your expert directions
>
>Vincentos|||Sue Hoegemeier <Sue_H@.nomail.please> wrote in message news:<nt5slv8t2643549b0datshnbl3tuq3b7ma@.4ax.com>...
> Use the example in the first link:
> http://www.sqlservercentral.com/scripts/contributions/263.asp
> and don't pass in a user name. It will go through all the
> users in the database.
> -Sue
> On 8 Sep 2003 11:29:56 -0700, wumutek@.yahoo.com (Vincento
> Harris) wrote:
> >Sue Hoegemeier <Sue_H@.nomail.please> wrote in message news:<jkjhlv0bidmj1okqgelfjijbks41sgc0et@.4ax.com>...
> >> Most of the web sites have scripts for this. SQL Server
> >> Central has several - these are links to some of the
> >> scripts:
> >> http://www.sqlservercentral.com/scripts/contributions/263.asp
> >> http://www.sqlservercentral.com/scripts/contributions/573.asp
> >> http://www.sqlservercentral.com/scripts/contributions/268.asp
This seemed very useful thanks to Randy dyess
http://www.transactsql.com/Articles/NEPII.html
Vince

No comments:

Post a Comment