Re: Permission denied in table yet allowed access in Sproc but still no access

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Graeme Malcolm (graemem_cm_at_hotmail.com)
Date: 08/25/04 

Date: Wed, 25 Aug 2004 13:03:44 +0100

Has the user (or any of the roles it belongs to) been explicitly denied
permissions on the sproc? (A DENY overrides a GRANT).
Can you post some sample DDL and query code? 

-- 
----
Graeme Malcolm
Principal Technologist
Content Master Ltd.
www.contentmaster.com
"ryu" <blizzardstorm8899@yahoo.com> wrote in message 
news:%235V2F4oiEHA.632@TK2MSFTNGP12.phx.gbl...
I have checked. The owner for both obj is dbo
"Graeme Malcolm" <graemem_cm@hotmail.com> wrote in message
news:uxJwHsoiEHA.3876@TK2MSFTNGP12.phx.gbl...
> Is the base table owned by the same user as the sproc? SQL Server checks
> permissions at each break in the ownership chain, so if the owners are
> different then the permissions on the base table would be applied.
>
> Cheers,
> Graeme
> -- 
> ----
> Graeme Malcolm
> Principal Technologist
> Content Master Ltd.
> www.contentmaster.com
>
>
> "Ryu" <blizzardstorm8899@yahoo.com> wrote in message
> news:%23yl6zfoiEHA.1356@TK2MSFTNGP09.phx.gbl...
> Hi all,
>
> I understand that when I am denied access from the table but given the
> right
> permission in a sproc accessing the table, I am still able to access the
> table. However
> I have a table which I am denied access but given the correct permission
> yet
> I am still not able to access. I have checked the roles and they seem
> fine.
> What else can I check?
>
>
>
>

Relevant Pages

  • Re: Sproc Permissions on Broken Ownership Chain
    ... The only way to maintain an unbroken ownership chain here is for the ... execute permissions on the proc. ... > has EXEC permission on sproc x.mysproc. ... y.theirtbl (owner must stay y as this is table for ...
    (microsoft.public.sqlserver.security)
  • Re: Permission denied in table yet allowed access in Sproc but still no access
    ... Is the base table owned by the same user as the sproc? ... permissions at each break in the ownership chain, ... different then the permissions on the base table would be applied. ... I understand that when I am denied access from the table but given the right ...
    (microsoft.public.sqlserver.programming)
  • execute permissions and scheduled jobs
    ... sp_update_jobschedule sproc from a table trigger. ... that when the records are inserted into the table, which in turn executes the ... I've found that the sp_update_jobschedule sproc has execute permissions ...
    (microsoft.public.sqlserver.security)
  • Re: Permission denied in table yet allowed access in Sproc but still no access
    ... The owner for both obj is dbo ... > different then the permissions on the base table would be applied. ... > permission in a sproc accessing the table, I am still able to access the ... > I have a table which I am denied access but given the correct permission ...
    (microsoft.public.sqlserver.programming)
  • Sproc Permissions on Broken Ownership Chain
    ... selects and updates from various tables ... without the user of the stored procedure needing ... has EXEC permission on sproc x.mysproc. ... to need permissions granted to the user of the sproc. ...
    (microsoft.public.sqlserver.security)