Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

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


Group: General Forum Members
Last Login: Thursday, May 5, 2016 1:56 PM
Points: 105, Visits: 363
We have developed a system to grant access to procedures through certificates. This was done following Erland Sommarkog excellent article on this subject ( ). 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,
Post #1413016
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse