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

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 (AT) gmail (DOT) com> wrote