Re: SQL 7.0 Stored Procedure Execute Privileges Only?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Not directly, you have to create a database role and give that execute
permissions on the stored procedures. Then you add the user to the role.

--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com


"Edbar" <edbar@xxxxxxxxxx> wrote in message
news:usT%f.1353$pi6.738@xxxxxxxxxxxxx

SQL 7.0 Stored Procedure Execute Privileges Only?

Does anyone know if a user/pass can be set up to give
a sql 7.0 user stored procedure execute privileges only.

That way, even if they get into the database, they can
do nothing except run the stored procedures.

Thanks,
Ed




.

Relevant Pages

  • How do I do Paging through a large dataset via Stored Procedures
    ... Paging by dynamically altering the SQL Query ... Create stored procedures ... SELECT * FROM STUDENTS ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Help with Stored Procedure
    ... I did mean stuff like system stored procedures (even ... build the query, compile it, and optimize it, then, then this is less ... very not easy using dynamic sql. ...
    (microsoft.public.sqlserver.programming)
  • Re: choices regarding where to place code - in the database or middle tier
    ... Sure, the DBMS is a good place for simple referential integrity constraints, ... to 4 separately-running-but-pipelined stored procedures, ... A typical user would enact a 100 or so business functions per day. ... own stored procedures' by storing the SQL for every business query in the DBMS ...
    (comp.lang.java.databases)
  • Re: choices regarding where to place code - in the database or middle tier
    ... Sure, the DBMS is a good place for simple referential integrity constraints, ... to 4 separately-running-but-pipelined stored procedures, ... A typical user would enact a 100 or so business functions per day. ... own stored procedures' by storing the SQL for every business query in the DBMS ...
    (comp.lang.java.programmer)
  • Re: Serious errors with Create view command
    ... the database is opened? ... There's no database on earth that behaves that way! ... What on EARTH does the option of 'Edit Stored procedures' do? ... I can't paste it INTO the view designer sql view ...
    (microsoft.public.fox.helpwanted)