Re: Stored procedures security
From: Keith Kratochvil (sqlguy.back2u_at_comcast.net)
Date: 10/27/04
- Next message: Tony Rogerson: "Re: If statement in View"
- Previous message: Dejan Sarka: "Re: Stored procedures security"
- In reply to: Nikolay Petrov: "Stored procedures security"
- Next in thread: Jacco Schalkwijk: "Re: Stored procedures security"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 27 Oct 2004 08:22:27 -0500
Make sure that the public role does not have select/insert/update/delete
rights on the tables.
In order to allow a user to execute stored proceduers:
GRANT EXEC on StoredProcedureName TO TheUser
You could create a stored procedure that will issue the appropriate GRANT
EXECUTE statements to the specific user.
-- Keith "Nikolay Petrov" <johntup2_nospam_@mail.bg> wrote in message news:OF4$ISCvEHA.1308@TK2MSFTNGP09.phx.gbl... > I have db where I want a specified user to be allowed only to run stored > procedures. > How to grant permissions to these stored procedures and deny access to all > other functions? > > TIA > >
- Next message: Tony Rogerson: "Re: If statement in View"
- Previous message: Dejan Sarka: "Re: Stored procedures security"
- In reply to: Nikolay Petrov: "Stored procedures security"
- Next in thread: Jacco Schalkwijk: "Re: Stored procedures security"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
