Using synonyms in security



Hello there

When i using select from table in store procedre at the same database, the
user who runs this who is not db_owner does need only grant exec on
procedure and not grant select.

However if the table which called from store procedure is not in the same
database as store procedure is, i need to grant select to table.

On synonyms its looks the same. is there a solution for this?


.



Relevant Pages

  • Thank you very much...again
    ... Sue: ... the grant select on tempdb will ... not work if the store procedure is in master database. ... The way I did it is to create the store procedure in the ...
    (microsoft.public.sqlserver.security)
  • Re: Thank you very much...again
    ... exists in tempdb so all users have access to tempdb through ... database which would avoid some of this. ... the grant select on tempdb will ... >not work if the store procedure is in master database. ...
    (microsoft.public.sqlserver.security)
  • Permission Problems for Newbies
    ... Grant a user for viewing all store procedure on a database without modify ... Can I grant the user permission to view job content and/or ...
    (microsoft.public.sqlserver.security)
  • Re: Permission Problems for Newbies
    ... Users can execute sp_helptext to view the text of stored ... Grant a user for viewing all store procedure on a database without modify ...
    (microsoft.public.sqlserver.security)
  • RE: user permissions in a database as a whole or tables
    ... user permissions in a database as a whole or tables ... The way to give permissions to a user is a simple GRANT. ...
    (comp.databases.informix)