Where are the permissions documented?



Under what topic in BOL is the meaning of the various permissions such as
"Alter", "References", etc., documented?

In other words, where is it documented, what you can DO if you have been
granted "References" or "Impersonate" permission on a securable?

I'm looking in SQL 2005.

I have looked in Permissions:listed and Permissions:objects and
Permissions:types, and several other topics, but no luck so far. It's as
if the meanings of the various permissions are supposed to be obvious.

Permissions:listed shows some of them; it explains "Alter" but not
"Delete", for example. Some of the permissions, such as "References", are
not documented anywhere that I can find.


David Walker
.



Relevant Pages

  • Re: prevent rename and copy on a specific file
    ... i have a file in a shared folder. ... You would actually have to remove the "write" permissions to ANYWHERE ... Meaning the user could have no effective My Documents/Home directory, ...
    (microsoft.public.windows.server.general)
  • re:fopen() question
    ... Well this may be happening because of some server updates, ... check beside permissions also if you still own those files, meaning ... Prev by Date: ...
    (comp.lang.php)
  • Re: file permissions
    ... I am new to Ubuntu and I am having problems finding out how to change ... Note that `execute' permissions are only useful on a) directories, ... S can be a hyphen, meaning a normal file, a `c', indicating a character device file, a `b', meaning a block device file, or a `d', meaning a directory. ... Then follows is the same `permission' set for user, group and others: --- means no permissions, rwx means read, write and execute permissions, ...
    (Ubuntu)
  • Re: Explorer.exe appears to hang on login
    ... fwiw I had a similar issue and it was because permissions had become ... corrupt for the Current User hive in the registry. ... Meaning the ...
    (microsoft.public.vb.general.discussion)
  • RE: Programatically find out stored procedures properties
    ... I did some searching in BOL since this is something that could be usefull ... This example lists the permissions for the titles table. ... This example lists all permissions that user Judy has in the current database. ...
    (microsoft.public.sqlserver.programming)