Hi,

I have an application role created on Database1 that has execute permission
for one stored procedure.
but need to have a select permission on two tables on Database2. What is
the best work around for this?


Many thanks

Mo


This communication contains information which is confidential and may be
legally privileged and is for the exclusive use of the addressee(s). If you
are not a named addressee please contact the sender immediately, and delete
the communication from your system. You are hereby notified that any
disclosure, distribution or copying of this communication, in whole or in
part, is strictly prohibited. Any views or opinions presented are solely
those of the author and do not necessarily represent those of the Company,
its directors or officers unless otherwise specifically stated. The Company
is not responsible for any reliance placed on the information contained
herein and excludes all liability.

(c)Copyright 2003 Siemens Energy Services Limited. All Rights Reserved.

MS Sql Server LazyDBA home page