Re: SQL Stored procedure access?

Erik Reiter (ErikReiter@xxxxxxxxxxxxxxxxxxxxxxx) writes:
I have a database with multiple schemas and each contains Tables, Views
and Stored Procedures. My users are on the intranet. I have a windows
application that the users run to Select, Insert, Update, and Delete
data from the database through the Stored Procedures and Views. No
users have access to the base tables in the database. My question is:
How do I allow the users to run queries against the views in SQL Server
Enterprise Manager, but not execute the Insert, Update, and Delete
Stored Procedures?

I will have to start to ask which version of SQL Server you are using.
When you talk about schemas, that makes me think that you are on SQL 2005,
but then you mention Enterprise Manager which is for SQL 2000/7 only,
so I don't really know.

And when it comes to security, the answers for SQL 2000 and SQL 2005 are
often quite different, as SQL 2005 saw a great overhaul in this area.


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: SQL Server 2000 Books On-Line
    ... Help topics associated with the Help icon are for Microsoft Management ... To open Books Online from Enterprise Manager, from the tool bar select View ... SQL Server Documentation Team ...
    (microsoft.public.sqlserver.setup)
  • Extreme performance issues (SQL Server 2000/ADO.NET/C#)
    ... This process runs very quickly if run through Query ... same exact stored procedures and views, run in the same exact order, through ... system that runs SQL Server (a 4-cpu Xeons system with 2gigs of physical ... When I execute these steps manually through query analyser,, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Help with SQL 2005 and Sourcesafe 6
    ... That doesn't seem to be the case with stored procedures. ... compile that latest version to be table to use it. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.tools)
  • Re: Securing Stored Procedures from being seen
    ... username, but in SQL Server, there are too many users to map an individuals ... granting the group execute permissions. ... but I would have to know what groups the user belongs ... see the names of any stored procedures to which he has no rights. ...
    (microsoft.public.sqlserver.security)
  • Re: nested stored procedures and returning lots of rows
    ... I initially thought of using nested stored procedures and returning ... proc then the called stored procs can't see it ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)