Re: user security
- From: "Leon McCalla" <leonmccalla@xxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 23 Jan 2007 08:04:13 -0500
thanks
"Hari Prasad" <hari_prasad_k@xxxxxxxxxxx> wrote in message
news:eYFEXvuPHHA.4172@xxxxxxxxxxxxxxxxxxxxxxx
Hello,
Just give EXECUTE rights to the user for the required procedure.
eg:-
Grant EXEC ON proc_name to Username
Thanks
Hari
"Leon McCalla" <leonmccalla@xxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:ua8zB2rPHHA.4244@xxxxxxxxxxxxxxxxxxxxxxx
how do i set sql2000 so that a user can only read or execute
user-stored-procedures?
Leon
.
- References:
- user security
- From: Leon McCalla
- Re: user security
- From: Hari Prasad
- user security
- Prev by Date: Re: user security
- Next by Date: Re: Can't access linked server, except from
- Previous by thread: Re: user security
- Index(es):
