permissions in proc

I have noticed that our procs have permissions for a given user id inside th
e
proc.
Once that user id gets dropped, all our procs would fail. What is the best
practice on assigning user permissions for the proc?
tia...Trisha wrote:
> I have noticed that our procs have permissions for a given user id
> inside the proc.
> Once that user id gets dropped, all our procs would fail. What is the
> best practice on assigning user permissions for the proc?
> tia...
Can you give an example of what you mean by "inside the proc"? Are you
saying that inside your procedures you have code that resembles:
If suser_sname() = 'dgreen'
Begin
-- Do stuff
End
Normally, you would grant execute rights to those security groups/users
that require access to the procedure using GRANT.
David Gugick
Imceda Software
www.imceda.com