user defined database roles - permissions

• srawant

  SSCommitted

  Points: 1829

  More actions

  October 17, 2008 at 2:12 pm

  #383140

  Hi guys,

  I create a database role. How do I provide the object permission to this database role with the T-SQL Script. Where these information(object level permission) for this particular database role( UDDR) stored ie the system tables..

  Please reply

• SQLBOT

  SSCrazy Eights

  Points: 8014

  More actions

  October 17, 2008 at 2:29 pm

  #886668

  you use the grant statement to grant access to an object by a securable

  deny will do the opposite.

  http://msdn.microsoft.com/en-us/library/ms187965(SQL.90).aspx

  I query this information with sp_helprotect, but its also found in sysprotects in each database but not in quite as nice a fashion.

  http://msdn.microsoft.com/en-us/library/ms178564(SQL.90).aspx

  Craig Outcalt

  ---

  
  Tips for new DBAs: http://www.sqlservercentral.com/articles/Career/64632
  My other articles: http://www.sqlservercentral.com/Authors/Articles/Craig_Outcalt/560258