|
Home > Archive > MS SQL Server DTS > July 2005 > Object level permissions for the role PUBLIC in SQL Server
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Object level permissions for the role PUBLIC in SQL Server
|
|
| sureshng1506@gmail.com 2005-07-21, 9:23 am |
| Hi,
I am trying to determine a way (query) through which i can find all the
objects and the kind of permissions (Select, Insert...) the role Public
& in turn all the users on this system have access to, by default.
Thanks,
Suresh NG
| |
| Ilya Margolin 2005-07-22, 7:23 am |
| Suresh,
Every user of a database belongs to public role. See "public Role" article
in BOL. The default permissions can be effectively modified by denying an
action. Is this what you need to see?
Ilya
<sureshng1506@gmail.com> wrote in message
news:1121954788.015141.153140@g14g2000cwa.googlegroups.com...
> Hi,
>
> I am trying to determine a way (query) through which i can find all the
> objects and the kind of permissions (Select, Insert...) the role Public
> & in turn all the users on this system have access to, by default.
>
> Thanks,
> Suresh NG
>
|
|
|
|
|