Re: Roles in 2005
- From: "Uri Dimant" <urid@xxxxxxxxxxx>
- Date: Thu, 17 May 2007 11:18:26 +0300
James
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_pa-pz_6f78.asp>
How can I retrieve a list of objects and permissions for a specified role?
"James" <minorkeys@xxxxxxxxx> wrote in message
news:%23onssm$lHHA.3996@xxxxxxxxxxxxxxxxxxxxxxx
Our DBA has recently left us so I've been tasked with determining how the
permissions are set up on a SQL Server 2005 box. I'm using SQL Server
Management Studio to try to assess this. Presently in one of the
databases, there is a role he defined which I know is widely used. When I
right-click the role and go to properties, none of the schemas are checked
as "owned". There's basically nothing listed under the "Securables" tab
and likewise for Extended Properties. Somewhere the permissions are
defined for this role, I just don't know where. This tool is beyond
counter-intuitive.
Essentially: How do I see and manipulate the permissions for a
user-defined role (or any for that matter) from within Sql Server
Management studio?
Thank you very much
.
- References:
- Roles in 2005
- From: James
- Roles in 2005
- Prev by Date: Re: Problem with SQL Server 2005 Express Edition
- Next by Date: Re: .ldf files
- Previous by thread: Roles in 2005
- Next by thread: Re: Roles in 2005
- Index(es):
Relevant Pages
|
|
