locked
row level permissions RRS feed

  • Question

  • is there a simple procedure to run to find what the row level permissions are on each user?

     

    thanks.

    Wednesday, September 26, 2007 9:53 PM

Answers

  • Take a look at the INFORMATION_SCHEMA.TABLE_PRIVILEGES view. This might provide the detail you're looking for.

     

    HTH!

    Thursday, September 27, 2007 3:01 PM
  • or you can use sp_helprotect /sys.database_permissions and fn_builtin_permissions to get the permission on objects.

     

    Read about

    SP_HELPROTECT/sys.database_permissions (sql server 2005) in BOL

     

    Madhu

     

    Friday, September 28, 2007 4:32 AM

All replies

  • I am not clear with the requirement. There is no row level permission in sql server if its refering to Table rows. You can give table level permission or you can create views as per the conditions and give permission to views.

     

    Madhu

    Thursday, September 27, 2007 7:28 AM
  • I should clearify.  I'm looing for table level permissions.  I assume there is a simple procedure to run to find this information for each user.

     

    Thursday, September 27, 2007 1:46 PM
  • Take a look at the INFORMATION_SCHEMA.TABLE_PRIVILEGES view. This might provide the detail you're looking for.

     

    HTH!

    Thursday, September 27, 2007 3:01 PM
  • or you can use sp_helprotect /sys.database_permissions and fn_builtin_permissions to get the permission on objects.

     

    Read about

    SP_HELPROTECT/sys.database_permissions (sql server 2005) in BOL

     

    Madhu

     

    Friday, September 28, 2007 4:32 AM