Re: database role vs. object permissions

From: Tibor Karaszi (tibor.please_reply_to_public_forum.karaszi@cornerstone.se)
Date: 03/26/03 

From: "Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@cornerstone.se>
Date: Wed, 26 Mar 2003 16:21:48 +0100

jj,

EM doesn't show effective permissions. Only permissions assigned directly. 

--
Tibor Karaszi, SQL Server MVP
For help on TSQL, please provide code we can execute in Query Analyzer
"jj" <jeff_detoro@urmc.rochester.edu> wrote in message
news:#8Dpjr68CHA.3236@TK2MSFTNGP11.phx.gbl...
> Hello all,
> Can anyone tell me why database role permissions do not show up in
> Enterprise Manger when you are looking at object permissions. I mean if the
> user is a "datareader" shouldn't the "select" object permssions be checked
> on all the objects?
>
> TIA
> jj
>
>

Relevant Pages

  • 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)
  • Re: remove user exe execute permission
    ... be able to read or execute the file. ... In NTFS grant - read and execute ... remove the 'read' permission of that folder. ...
    (microsoft.public.windows.server.security)
  • Re: Connecting to Sql Server 2005
    ... When you create the logon (or alter the login) in Enterprise Manager ... allows it the permissions it will need. ... executes the sp's I get the infamous EXECUTE permission denied on object ... I am using sql server authentication - I created a SQL server user in the ...
    (microsoft.public.dotnet.general)