Re: Database Role that allows execution of stored procedures?
From: Narayana Vyas Kondreddi (answer_me_at_hotmail.com)
Date: 10/30/04
- Next message: Narayana Vyas Kondreddi: "Re: Make a same copy of SQL Server to a new machine"
- Previous message: Laurence Neville: "Database Role that allows execution of stored procedures?"
- In reply to: Laurence Neville: "Database Role that allows execution of stored procedures?"
- Next in thread: Laurence Neville: "Re: Database Role that allows execution of stored procedures?"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 30 Oct 2004 10:56:01 +0100
No built-in role like that in SQL Server 2000. You'll have to create your
own database role, and give it the required permissions. This might help:
http://vyaskn.tripod.com/generate_scripts_repetitive_sql_tasks.htm
-- Vyas, MVP (SQL Server) SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/ "Laurence Neville" <laurenceneville@hotmail.com> wrote in message news:OHbd5VmvEHA.3624@TK2MSFTNGP09.phx.gbl... > We have a rule for developing database-driven applications that all > interaction with the database must be done through stored procedures i.e. > all selects, inserts, updates etc. > > I am looking for simple ways to enforce & support this design principle - > and one would be if I could put the SQL login that the application uses into > a database role(s) that only allowed execution of stored procedure, i.e. no > direct access to tables or views. I know that the long way to do this is to > create my own role and grant it execute rights on each SP and no rights to > tables/views, but I was wondering if there was anything already built into > SQL Server. > >
- Next message: Narayana Vyas Kondreddi: "Re: Make a same copy of SQL Server to a new machine"
- Previous message: Laurence Neville: "Database Role that allows execution of stored procedures?"
- In reply to: Laurence Neville: "Database Role that allows execution of stored procedures?"
- Next in thread: Laurence Neville: "Re: Database Role that allows execution of stored procedures?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
