Re: permission window
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Sat, 17 Feb 2007 15:24:14 +0000 (UTC)
farshad (farshad@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
Running sql server 2005 standard edition (SP1).
Server properties, permissions window seems to be different to what it
should be.
In this window I do not see System Administrator and System User column. I
see a different window i.e. permission, Grantor, Grant, WithGrant, Deny
columns.
Any thoughts please?
Not really sure what you expect to see, but what you see is the server-level
permissions for a user, from whom he got it, and whether the permission
was granted or denied.
Keep in mind that the permissions structure has changed radically in SQL
2005, and is now far more complex than before. At the same time it's easier
to use, since you can grant a permission like EXEC on a schema, and it will
be inherited to procedure level.
There are some functions to display permissions: fn_my_permissions
and has_perms_by_name, and you can also query the catalog views directly.
But I have a feeling that more is needed.
The permissions dialogs in Mgmt Studio does a very poor job to show you
what the current permissions are. This particlar dialog you found is one
of the better.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Prev by Date: Re: Programatically Create User Login
- Next by Date: Re: change ownership of objects
- Previous by thread: Re: Programatically Create User Login
- Next by thread: sql server 2000: How to prevent users to see databases apart their own
- Index(es):
Relevant Pages
|
|
