If it's going through a service, then it will be the service's account whose
credentials and permissions are checked. If you want to use user X, then
you will have to use delegation.
--
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
..
"Curtis" <Curtis@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:9123DDE4-466A-45BB-8CF4-B7233F34E500@xxxxxxxxxxxxxxxx
Hello All,
I'm confused about permissions...
I have user X, who is a member of db_owner role.
I have stored procedures owned by dbo.
The database is owned by dbo (sa).
User X is making a connection from a "service", executing the stored
procedure,
but gets the "Execution permission denied" error...
I've checked for deny permissions but haven't found any related to user X...
It's my understanding that the db_owner has all permissions to do anything
within
the database... If this is incorrect, could someone recommend a good
book/white paper defining permissions... I would greatly appreciate it...
Re: How to prevent DELETEs in a table ... It is the dbo database USER, not server-level groups, that determins ... It has implicit permissions that can not be denied. ...SQL Server just skips any permission validation for sysadmins. ... (microsoft.public.sqlserver.server)
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)
Re: Delegate Power of God to only 1 database - How? ... Guess I'll have to look more closely at the permissions... >I support the Professional Association for SQL Server... >> permissions to only that database which can be assigned ... >>>Exactly what is this 'dBO' role you are referring to? ... (microsoft.public.sqlserver.security)
Re: List Users Permissions down to table.column action ... THIS STORED PROCEDURE GENERATES COMMANDS... -- FIXED PROBLEMS WITH STATEMENT LEVEL PERMISSIONS GRANTING.... -- CREATE TABLE TO HOLD LIST OF USERS IN CURRENT DATABASE... -- GRANT USER ACCESS TO SERVER ROLES... (microsoft.public.sqlserver.security)
Re: User access on a company intranet ... Yes they need full permissions on the folder where the backend is. ... You wouldn't need to do this in your copy of the database.... However you can toggle the shiftkey bypass from another mdb file.... When you want to implement security, you create a new mdw file,... (microsoft.public.access.security)
