Application Role

From: Amitabha (amitinfy_at_yahoo.com)
Date: 09/29/03 

Date: Mon, 29 Sep 2003 02:40:36 -0700

Hi
I am trying to activate application role say 'abc' from my
VB application using RDO I am able to execute
sp_setapprole but there is some problem regarding the
Group permissions.
I want user 'A' not to have any execute permission on
object 'O' so I revoked the permissions on the user. By
default user goes to grp 'public' to be safe I revoked the
permissions from 'public' now in the application I
activated application role 'AR' this role has all the
necessary permissions now I tried to execute some Proc
using the same connection but SQL Server gives error as
"user doesn't have execute permission on the object 'O' "
This shouldn't happen with the application role as
application role takes over group and user level
permissions from the point it is active.

Any info on this will be of help to me.

Thanks
Amitabha

Relevant Pages

  • Solaris 10 autofs directory permissions - Solution
    ... the fact that my map file has 755 permissions not 644. ... If the execute permission is set, it becomes an executable map which is ... map is expected to return the content of an automounter map ...
    (SunManagers)
  • Re: Rights to execute jobs?
    ... Does anyone know if the rules surrounding stored procedure permissions apply ... Does this apply to a proc calling sp_start_job so that I ... raise the alert, so it could be anyone on the server. ... is that a group needs to not be an admin but still be able to execute ...
    (microsoft.public.sqlserver.security)
  • Re: Newbie
    ... I will now tell you some basic commands. ... Easy file has rights and a owner. ... file and who may execute it. ... The last three characters are about the permissions of user ...
    (alt.linux)
  • Re: Execute Persmission denied on object sp_OACreate
    ... SQL Server doesn't check permissions on indirectly referenced objects as ... You can prevent ad-hoc execution of powerful master database procs while ... >I have a user who has execute permissions on a store procedure in a>database> which in turns executes 4 stored procedures in the master database. ...
    (microsoft.public.sqlserver.security)
  • Application Role
    ... VB application using RDO I am able to execute ... Group permissions. ... I want user 'A' not to have any execute permission on ... object 'O' so I revoked the permissions on the user. ...
    (microsoft.public.sqlserver.security)