List of Permissions

Does anyone know how to get a listing of each user in a database and the
permissions each user has? I found sp_helplogins and that gives me some
information but I'm looking to get a listing of permissions down to the
object level.
Thanks!
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
Rachael,
permissions are held in sysprotects and sp_helpprotect can be used to list
them. Note that this applies to explicitly granted permissions and most
permissions in SQL Server are implied, by virtue of being in a role or an
object owner.
HTH,
Paul Ibison
|||Thank you! I'll give it a try.
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
|||Hi,
Join the syspermissions with spt_values table of master database to get the
details.
or else
use the system procedure SP_HELPROTECT to get the detailed information about
the object permissions.
sp_helprotect null,user_name (replace user_name with your user name)
Thanks
Hari
MCDBA
"Rachael" <rachael_faber@.hotmail.com> wrote in message
news:OlpU2LyTEHA.3872@.TK2MSFTNGP10.phx.gbl...
> Does anyone know how to get a listing of each user in a database and the
> permissions each user has? I found sp_helplogins and that gives me some
> information but I'm looking to get a listing of permissions down to the
> object level.
> Thanks!
>
> *** Sent via Devdex http://www.devdex.com ***
> Don't just participate in USENET...get rewarded for it!

List of Permissions

Does anyone know how to get a listing of each user in a database and the
permissions each user has? I found sp_helplogins and that gives me some
information but I'm looking to get a listing of permissions down to the
object level.
Thanks!
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!Rachael,
permissions are held in sysprotects and sp_helpprotect can be used to list
them. Note that this applies to explicitly granted permissions and most
permissions in SQL Server are implied, by virtue of being in a role or an
object owner.
HTH,
Paul Ibison|||Thank you! I'll give it a try.
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!|||Hi,
Join the syspermissions with spt_values table of master database to get the
details.
or else
use the system procedure SP_HELPROTECT to get the detailed information about
the object permissions.
sp_helprotect null,user_name (replace user_name with your user name)
Thanks
Hari
MCDBA
"Rachael" <rachael_faber@.hotmail.com> wrote in message
news:OlpU2LyTEHA.3872@.TK2MSFTNGP10.phx.gbl...
> Does anyone know how to get a listing of each user in a database and the
> permissions each user has? I found sp_helplogins and that gives me some
> information but I'm looking to get a listing of permissions down to the
> object level.
> Thanks!
>
> *** Sent via Devdex http://www.devdex.com ***
> Don't just participate in USENET...get rewarded for it!