Re: sql server 2005 permissions - how to view
- From: Sue Hoegemeier <Sue_H@xxxxxxxxxxxxx>
- Date: Thu, 16 Feb 2006 20:12:42 -0700
For databases, take a look at sys.database_permissions (and
sys.database_principals to get associated database user
information). For server level, look at
sys.server_permissions and sys.server_principals to get
associated login info.
-Sue
On Thu, 16 Feb 2006 08:38:32 -0800, "Mike"
<Mike@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Is there a Dynamic Management View (DMV) that would allow me to display
permissions for logins and roles?
Thank you.
.
- Prev by Date: Re: Adding role to roles?
- Next by Date: [SQL2000] permissions to use view based on tables from many databases
- Previous by thread: Re: Adding role to roles?
- Next by thread: [SQL2000] permissions to use view based on tables from many databases
- Index(es):
Relevant Pages
|
|
