Veiw Permissions

• GRE (Gethyn Ellis)

  SSCrazy Eights

  Points: 9602

  More actions

  December 6, 2007 at 7:28 am

  #93132

  Hi Guys,

  I want to create a database that contains views of tables in another database on the same server. I want to give permssions to a user on the views without giving the user permissions on the base tables(in the other database). Is this possible? If so what permssions will the users of the Views database need?

  Thanks

  Gethyn Elliswww.gethynellis.com

• Jo Pattyn

  SSC-Dedicated

  Points: 32350

  More actions

  December 6, 2007 at 11:14 am

  #757789

  You might be able to do that with "cross-database ownership chaining".

  It is in the security tab of the server.

  Beware of the security risk:

  http://www.sqlservercentral.com/articles/Security/2633/