Permission error using IDENT

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Compact Edition » Permission error using IDENT_CURRENT

Permission error using IDENT_CURRENT

Rate Topic

Display Mode

Topic Options

Author

Message

Eduardo Olivera

Posted Tuesday, January 29, 2013 6:49 AM

Valued Member

Group: General Forum Members
Last Login: Monday, April 08, 2013 10:20 AM
Points: 65, Visits: 201

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 »

Permissions