Re: Grant permissions

From: Arun (arunkkk_at_yahoo.com)
Date: 09/28/03 

Date: Sun, 28 Sep 2003 02:33:07 -0700

This is actually for deployment of a web application, so I
would be doing this whole exercise only once
Thanks

>-----Original Message-----
>A better solution is to create a role that has
permissions to execute
>all the stored procedures in the database, and just add
the user to
>the role. That way when the situation arises in the
future you'll just
>need to add a new user to that role, which is one line of
code.
>
>-- Mary
>MCW Technologies
>http://www.mcwtech.com
>
>On Wed, 24 Sep 2003 00:22:20 -0700, "Arun"
<arunkkk@yahoo.com> wrote:
>
>>Can I grant execute permission to all stored procedures
in
>>a database to an user in a single statement
>>
>>grant execute on all to <user name> doesn't work !
>
>.
>

Relevant Pages

  • Re: Infinite Loops and Explicit Exits
    ... the whole payroll system would be dependent on proper database ... I design large systems the same way. ... Stored procedures ARE application code. ... any language, including Cobol. ...
    (comp.lang.cobol)
  • Re: Infinite Loops and Explicit Exits
    ... The behaviour could only be changed by changing the database. ... >>designing proper databases and using stored procedures on them, ... are database dependent and not available in COBOL. ... But with extended SQL you simply write the procedures in SQL ...
    (comp.lang.cobol)
  • Re: Portable stored procedures
    ... > JDatastore also uses java as the language for its stored procedures. ... and the database itself is written in java. ...
    (comp.lang.java.databases)
  • Re: Storing Connection String
    ... if the credentials you use for your application can only execute ... SSPI security is more expensive to ... My idea is to have just one database user whose username and password ... As per database I would use only stored procedures to ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Selecting Rows in groups
    ... to write stored procedures ... solid data architecture ... determining the types of database calls - chunky or chatty. ... Builds the Select clause for the query based on the data ...
    (microsoft.public.sqlserver.programming)