MS SQL Server - where are permissions stored?

Author

where are permissions stored?

bing

2006-03-05, 8:24 pm

Hi,

I apologize first if this is a duplicate post. When I finished and clicked
post, I was brought up the login page, after logging in, I was brought back
to a new empty New Question page. It's supposed to tell me my question has
been successfully posted. Weird. Anyway, here is my question again.

Using sp_helplogins, I'm able to see each login mapping to what database
user and in what database role. I also need to know what permissions each
database user or database role has on each table for a given database. How
should I do that?

Thanks in advance,

Bing

Linchi Shea

2006-03-05, 8:24 pm

Look up sp_helprotect in Books Online.

Linchi

"bing" wrote:

> Hi,
>
> I apologize first if this is a duplicate post. When I finished and clicked
> post, I was brought up the login page, after logging in, I was brought back
> to a new empty New Question page. It's supposed to tell me my question has
> been successfully posted. Weird. Anyway, here is my question again.
>
> Using sp_helplogins, I'm able to see each login mapping to what database
> user and in what database role. I also need to know what permissions each
> database user or database role has on each table for a given database. How
> should I do that?
>
> Thanks in advance,
>
> Bing

bing

2006-03-06, 7:16 pm

Thanks for the information. That's pretty close to what I needed. In the
result returned, the 'Column' column of some entries have '.'. Others have
(ALL+New). What does dot mean? I've looked up sp_helprotect in the online
book, but it does not have any explanation about the dot.

Thanks,

Bing

"Linchi Shea" wrote:
[color=darkred]
> Look up sp_helprotect in Books Online.
>
> Linchi
>
> "bing" wrote:
>

Ragnar Midtskogen

2006-03-06, 7:16 pm

This may not be exactly what you are looking for, but all logins and
passwords are stored in the master database, I think other security info is
stored there as well..

Ragnar

"bing" <bing@discussions.microsoft.com> wrote in message
news:F8648164-E7F1-4141-8A77- 002053387A05@microso
ft.com...[color=darkred]
> Thanks for the information. That's pretty close to what I needed. In the
> result returned, the 'Column' column of some entries have '.'. Others
> have
> (ALL+New). What does dot mean? I've looked up sp_helprotect in the
> online
> book, but it does not have any explanation about the dot.
>
> Thanks,
>
> Bing
>
> "Linchi Shea" wrote:
>

Sponsored Links