none
Type of Object Permissions

    Question

  • Hi,

    I need find table which have all type of permissions to all type of object not specific for user only general information

    For example

    USER_TABLE Select
    USER_TABLE ALTER
    USER_TABLE UPDATE
    USER_TABLE View DEFINITION
    ......
    ......

    VIEW Update
    VIEW Select
    VIEW Alter
    AGGREGATE_FUNCTION ...
    AGGREGATE_FUNCTION ...
    ....
    CHECK_CONSTRAINT ....
    CHECK_CONSTRAINT ...
    ......
    CLR_SCALAR_FUNCTION ....
    ...
    ...

    Some like that table exist or that information is somewhere?

    In that site is only show general definition about type of permissions to object
    http://technet.microsoft.com/en-us/library/ms188371(v=sql.110).aspx

    I need more detailed information

    I will be very grateful for answer


     

    Tuesday, July 22, 2014 10:27 PM

Answers

  • Hi wodzion,

    According to your description, usually, we can grants permissions on a table, view, table-valued function, stored procedure,

    extended stored procedure, scalar function, aggregate function, service queue, or synonym. And there are major classed of permission, such as select, view change tracking, update, references, insert, delete, execute, receive, view definition, alter, take ownership, control impersonate. If you want to fine a complete list of SQL Server permissions, you can review the following article about permission.

    http://msdn.microsoft.com/en-us/library/ms191291.aspx

    In addition, you should note that the grantor must have either the permission itself with GRANT OPTION, or a higher permission that implies the permission being granted.

    Regards,
    Sofiya Li


    Sofiya Li
    TechNet Community Support

    Thursday, July 24, 2014 3:36 AM
    Moderator