Re: Grant Execute on Proc
From: Dan Guzman (danguzman_at_nospam-earthlink.net)
Date: 11/20/03
- Next message: bill: "sql server"
- Previous message: Allan Mitchell: "Re: Grant Execute on Proc"
- In reply to: Anand: "Grant Execute on Proc"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 20 Nov 2003 07:52:05 -0600
One needs to have CREATE TABLE permissions in order to create permanent
tables. However, users without CREATE TABLE rights can still create
temporary tables. Perhaps a temporary table is appropriate here since
your creating and dropping the table in your proc.
-- Hope this helps. Dan Guzman SQL Server MVP ----------------------- SQL FAQ links (courtesy Neil Pike): http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800 http://www.sqlserverfaq.com http://www.mssqlserver.com/faq ----------------------- "Anand" <anonymous@discussions.microsoft.com> wrote in message news:0b6a01c3af47$40d1dca0$a301280a@phx.gbl... > Hello All, > > User "A" have Execute Privilege on all stored > procedures. > Inside one of the stored procedures a table gets created > and dropped. > When user "A" executes this stored procedure, it says that > he doesn't > have rights to create table. > How to solve this problem? Can something be done without > granting the user > CREATE TABLE privelege. Actually I don't want user "A" to > create any tables. > > Please Help, > > Regards > Anand
- Next message: bill: "sql server"
- Previous message: Allan Mitchell: "Re: Grant Execute on Proc"
- In reply to: Anand: "Grant Execute on Proc"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
