Re: Execute premmition

From: Roy Goldhammer (roygoldh_at_hotmail.com)
Date: 12/24/03 

Date: Wed, 24 Dec 2003 21:47:23 +0200

Thankes russell

But i don't like to work hard for this

there is probebly system store procedure that add the execution premmition
for some role.

There is also option to know which procedure is has already grant execute so
the procedure i want to build will allow me to update the role

Can you help me on it?

any help would be useful
"Russell Fields" <RussellFields@NoMailPlease.Com> wrote in message
news:#wbvU0kyDHA.3224@tk2msftngp13.phx.gbl...
> Roy,
>
> There is not a predefined role for stored procedures, so yes you will need
> to create one.
>
> Of course, you could write a little bit of code to generate a GRANT for
each
> stored procedure in the database to your general role. (Just need to
> remember when you add stored procedures to do it again.)
>
> Russell Fields
> "Roy Goldhammer" <roygoldh@hotmail.com> wrote in message
> news:uzZ9XykyDHA.3436@tk2msftngp13.phx.gbl...
> > Hello there
> >
> > I've add new user to my sql server.
> >
> > AS the default he got the public role.
> >
> > I add db_datawriter and db_datareader to the user.
> >
> > Now the user can enter data and read data but he can't execute store
> > procedures.
> >
> > Is there a role for executing stored procedures?
> >
> > if not is that mean that i have to create my owm role and pass stored
proc
> > one by one and allow it for the role?
> >
> > any help would be useful
> >
> >
>
>

Relevant Pages

  • Re: Execute premmition
    ... Here's a script like the one Russell alluded to. ... 'GRANT EXECUTE ON ' + ... >> There is not a predefined role for stored procedures, ...
    (microsoft.public.sqlserver.security)
  • Extreme performance issues (SQL Server 2000/ADO.NET/C#)
    ... same exact stored procedures and views, run in the same exact order, through ... system that runs SQL Server (a 4-cpu Xeons system with 2gigs of physical ... When I execute these steps manually through query analyser,, ...
    (microsoft.public.sqlserver.server)
  • Sybase, JDBC, AutoCommit, DDL IN TRAN
    ... having executing Sysbase stored procedures via JDBC. ... stored procedure which contains DDL and with AutoCommit set to false I ... The explanation for this behaviour I have found is that the JDBC ... I need to be able to set AutoCommit to false and execute multiple ...
    (comp.lang.java.databases)
  • Re: Sybase, JDBC, AutoCommit, DDL IN TRAN
    ... > having executing Sysbase stored procedures via JDBC. ... > stored procedure which contains DDL and with AutoCommit set to false I ... > The explanation for this behaviour I have found is that the JDBC ... > I need to be able to set AutoCommit to false and execute multiple ...
    (comp.lang.java.databases)
  • Re: Records lost in an ADOStoredProc
    ... Use a thread to fire off the stored procedures so that your application ... Let's suppose it updates ... > the CacheSize is set to 1; it is worse when I increase the CacheSize. ... > I don't need to show records, only to execute the store procedure. ...
    (borland.public.delphi.database.ado)