Re: doing select without grant
- From: "Uri Dimant" <urid@xxxxxxxxxxx>
- Date: Thu, 20 Mar 2008 15:01:14 +0200
Roy, sorry , I need to go home, a lot of work :-)))
Please read Erland's article about the subject
http://www.sommarskog.se/grantperm.html#Certificates
"Roy Goldhammer" <roy@xxxxxxx> wrote in message
news:es$OAhoiIHA.6092@xxxxxxxxxxxxxxxxxxxxxxx
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?
.
- References:
- doing select without grant
- From: Roy Goldhammer
- Re: doing select without grant
- From: Uri Dimant
- Re: doing select without grant
- From: Roy Goldhammer
- doing select without grant
- Prev by Date: Re: doing select without grant
- Next by Date: Re: doing select without grant
- Previous by thread: Re: doing select without grant
- Next by thread: Re: doing select without grant
- Index(es):
Relevant Pages
|
|
