Stored procedure to drop and create table for end user

From: Brian Henry (brianiupmsdn_at_newsgroups.nospam)
Date: 06/09/04 

Date: Wed, 9 Jun 2004 15:37:48 -0400

Hi,

I am using stored procedures in my application to keep the end users from
having permission on the database that they should not (like delete rows and
such) so the only thing the end user has access to is execute permission on
the stored procedures... BUT the problem is it sometimes (not always) comes
back with select permission not granted on a table the stored procedure is
trying to access... so i had to go through and give select access to the
tables (which i dont like doing considering some of them have sensative data
in them) i thought a stored procedure is independent of end users table
permissions? as long as they had execute permissions only the data returned
is what they should get... regardless of the table permissions (thought
stored proces ran as DBO or SA...) anyways, we need to give a single stored
procedure drop and create table access... which we dont want to grant it
wide open across the user base that would be bad... but a temp table needs
to be created and droped when its done with in the stored procedure... well
right now we get permission errors on it when this happens... what can i do
about this?! i dont want to give everyone SA access....

Relevant Pages

  • Re: pass stored procedure parameters in asp
    ... procedure and properties) of voidTran stored procedure and other ... I believe it is the permission issue. ... This email account is my spam trap ...
    (microsoft.public.inetserver.asp.general)
  • Re: Stored procedure to drop and create table for end user
    ... > having permission on the database that they should not (like delete rows and ... > such) so the only thing the end user has access to is execute permission on ... > back with select permission not granted on a table the stored procedure is ... > tables (which i dont like doing considering some of them have sensative data ...
    (microsoft.public.sqlserver.programming)
  • Re: EXECUTE permission denied on object... uh?
    ... connecting with doesn't have permission to execute the Stored Procedure ... runBehavior, SqlCommand cmdHandler, SqlDataReader ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: pass stored procedure parameters in asp
    ... GRANT Execute For dbo.voidTran NameOfUser ... I believe it is the permission issue. ... voidTran is a stored procedure for deleting records from the database. ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.general)
  • Re: INSERT Permission
    ... Please don't post the same question independently to multiple groups. ... SQL FAQ links: ... > I have a user with read permission on the table and execute permission ... > The stored procedure inserts the record in the table. ...
    (microsoft.public.sqlserver.security)
Loading