InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 20:34:27 GMT20http://www.sqlservercentral.com/Forums/Topic1413016-323-1.aspxWe 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,EduardoTue, 29 Jan 2013 06:49:43 GMTEduardo Olivera