Cross Database Privileges for Application Role

• dias__84

  Say Hey Kid

  Points: 686

  More actions

  February 23, 2011 at 11:10 pm

  #388927

  Hi everyone,

  I wish to check whether granting of privileges of different databases can be assigned to an application role.

  For example, grant select on database A's table and select on database B's table to one application role.

  Is there any recommended way for doing such granting of privileges across multiple databases ?

  For comments and advise.

  Thank You !

  Al

• Orlando Colamatteo

  SSC Guru

  Points: 182276

  More actions

  February 24, 2011 at 12:14 pm

  #1291198

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

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato