-
privilege
you have created a procedure DELETETABLE which uses dynamic sql to our remove a table in your schema. you have granted the EXECUTE privilege to a user X on this procedure
when user X executes the procedure under whose privilege are the operation performed bydefault
1.yours
2.user X
-
Re: privilege
under user X's privilage.
It user X does not has access to a table that is to be deleted in the procedure, it will throws an error.
-
Re: privilege
i st option is right
if u want that procedure should execute under user priv instead of ur privs u should include a keyword 'authid current_user' in create pocedure.
-
Re: privilege
Hi Gujjar,
Yeah, Smitai is right.
When you create a procedure, it will be executed under the privileges of the creator, unless the procedure has the [B]"AUTHID CURRENT_USER"[/B] statement.
If it is not mentioned explicitly, [B]by default, the procedure executes under the owner's privileges.[/B]
*** Innila ***
-
Re: privilege
Huh huh! That was news for me. I guess the same rules apply in SYBASE too. Recently when I created an SP with a DBA privileged login, an user without the DBA privilege could not run the report. I had to face some angry grunts from an old friend for that.
Ofcourse I resolved the issue rather simply. Just used "[B]grant[/B]" command to give execute privilege to everyone as I was unable to find the root cause of the problem then.
This post of [B]Innila[/B] does deserve a thanks :D
Cheers!
Kalayama
-
Re: privilege
hi
thanks to innila and smitai. this helped me for the correct answer