Newbie: Restrict user account access to stored procedures

From: Nathan (nahtan@email.com.nospam)
Date: 01/24/03 

From: "Nathan" <nahtan@email.com.nospam>
Date: Fri, 24 Jan 2003 17:09:23 +1300

I've got two accounts for my SQL Server database - the main one which I use
to add/edit/delete tables and stored procedures, and a dedicated user
account for my website.

I am manipulating all the data through stored procedures and would like to
be able to restrict the account that is used by the website only to the
stored procedures that I've created (none of the system stored procedures,
or any of the tables directly).

Is it possible to restrict a user account to the stored procedures only? I
know you can do it for each stored procedure individually, but is there a
global setting? (I don't want to have to set the permissions every time I
create a new stored procedure).

TIA.

Relevant Pages

  • Re: Convert SQL Account to Windows Accounts + EXEC on ALL SPs
    ... I have an SQL Server 2000 Database that has an "SQL Account" that has ... execute permission on all Stored procedures. ... This one account is used by "all workstations". ... I want to fix this and use Windows Accounts, and get rid of that SQL ...
    (comp.databases.ms-sqlserver)
  • Re: Stored Procs in SQL 2005
    ... How do i give execute privileges on stored procedures to an account? ... Arne Garvander ... Professional Data Dude ...
    (microsoft.public.sqlserver.security)
  • Re: change ownership of objects
    ... Fiirst of all change the password for his account to a one with special ... user to DBO. ... I am afraid to delete his account in fear all the stored procedures ...
    (microsoft.public.sqlserver.security)
  • Re: Display ADO recordset
    ... BillyRogers wrote: ... to be passed to the stored procedures based on account numbers ... entered into text boxes on the form. ...
    (microsoft.public.access.modulesdaovba)