Re: doing select without grant

Sorry uri.

But if there is dinamic sql inside the query I need Grant permission of what
happen in the tables

"Uri Dimant" <urid@xxxxxxxxxxx> wrote in message
news:uRhoBBoiIHA.5088@xxxxxxxxxxxxxxxxxxxxxxx
Roy
Grant EXECUTE permission on stored procedure



"Roy Goldhammer" <roy@xxxxxxx> wrote in message
news:uuwjMqniIHA.3740@xxxxxxxxxxxxxxxxxxxxxxx
Hello there

I have store procedure with dinamic sql which run select from 2 tables.

I want my users to run my store procedure without granting the select on
them.

How can i do it?





.

Relevant Pages

  • Re: doing select without grant
    ... Roy, sorry, I need to go home, a lot of work :-))) ... Grant EXECUTE permission on stored procedure ... I have store procedure with dinamic sql which run select from 2 tables. ...
    (microsoft.public.sqlserver.security)
  • Re: doing select without grant
    ... Grant EXECUTE permission on stored procedure ... I have store procedure with dinamic sql which run select from 2 tables. ...
    (microsoft.public.sqlserver.security)