Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Permission error using IDENT_CURRENT Expand / Collapse
Author
Message
Posted Tuesday, January 29, 2013 6:49 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, November 18, 2014 2:03 PM
Points: 99, Visits: 321
We have developed a system to grant access to procedures through certificates. This was done following Erland Sommarkog excellent article on this subject ( http://www.sommarskog.se/grantperm.html ). The procedure having a permission denied on the IDENT_CURRENT resides in a database that is exclusively composed of procedures. It was granted access to the database in question, including the table being sent as a parameter of the function but only in this case it returns a permission error. I haven't found any way, besides granting select to the user I am trying to prevent from accessing directly this table, to go around this issue. Has anyone encountered this issue and found a solution that they can share?
Thanks in advance,
Eduardo
Post #1413016
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse