user security

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Leon McCalla - 23 Jan 2007 07:10 GMT

how do i set sql2000 so that a user can only read or execute
user-stored-procedures?

Leon

Reply to this Message

Jens - 23 Jan 2007 07:56 GMT

Hi,

what do you mean by read the stored procedure ? By default new user are
not granted anything on the database. They are mapped to the public
role (like any other user) which by default contains no permissions.
granetd the permissions to execute a stored procedure can be done using
the GRANT EXECUTE ON SomeProcedurename TO SomeUsername.

HTH, Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---

Reply to this Message

Hari Prasad - 23 Jan 2007 12:41 GMT

Hello,

Just give EXECUTE rights to the user for the required procedure.

eg:-

Grant EXEC ON proc_name to Username

Thanks
Hari

> how do i set sql2000 so that a user can only read or execute
> user-stored-procedures?
>
> Leon

Reply to this Message

Leon McCalla - 23 Jan 2007 13:04 GMT

thanks

> Hello,
>
[quoted text clipped - 11 lines]
> >
> > Leon

Reply to this Message