Re: Grant Execute on Proc

From: Erland Sommarskog (sommar_at_algonet.se)
Date: 12/25/03

  • Next message: jecy_j_at_msn.com: "SQL 7.0 AND ACL AUDIT SOFTWARE" 
    Date: Thu, 25 Dec 2003 22:51:27 +0000 (UTC)

    Anand (anonymous@discussions.microsoft.com) writes:
    > 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.

    This is because the rights to CREATE TABLE are not transferable. Few
    statements outside the plain INSERT, DELETE, UPDATE and SELECT are in
    fact transferable.

    Why can't you use s temp table? 

    -- 
Erland Sommarskog, SQL Server MVP, sommar@algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
  • Next message: jecy_j_at_msn.com: "SQL 7.0 AND ACL AUDIT SOFTWARE"

    Relevant Pages

    • Re: Writing updates from a wide DataTable
      ... restrict IO rights to specific columns or trip over a column that can't be ... Creating your own UPDATE statement on the fly is what ADO classic did--based ... This posting is provided "AS IS" with no warranties, and confers no rights. ... >following the recommendations to use stored procedures to apply updates to ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: Grant Execute on Proc
      ... users without CREATE TABLE rights can still create ... "Anand" wrote in message ... > User "A" have Execute Privilege on all stored ... > Inside one of the stored procedures a table gets created ...
      (microsoft.public.sqlserver.security)
    • Re: Rename Extended stored procedures
      ... My advise would be to revoke rights and create stored procedures that wrap ... where XP's allow overloaded parameter type passing ... This posting is provided "AS IS" with no warranties, and confers no rights. ... > I've read on some sql security sites that dropping stored procedures is ...
      (microsoft.public.sqlserver.security)
    • Re: When to use Stored Procedures!
      ... > I am still new to Sql Server & lovin' it. ... you can revoke all rights ... Stored procedures have other benefits as well, ...
      (microsoft.public.sqlserver.server)
    • Re: Granting GRANT permissions
      ... Creators of stored procedures (standard users with CREATE PROCEDURE rights) ... can grant permissions on their own procedures to other users. ... "Josh N." ...
      (microsoft.public.sqlserver.security)