September 2, 2010 at 2:54 am
Hi!
Is there any way to override the permissions given to the database in relation to the server?
The scenario is:
Server Permissions:
For Public Role: DENY VIEW ANY DEFINITION
DENY VIEW ANY DATABASE
Database Permissions:
For user XPTO: GRANT VIEW ANY DEFINITION
XPTO can execute system stored procedures like sp_procedure_params_rowset but will not retrieve values!
With the dbowner is possível (what it's normal)
Without touching the server permissions, can I change this? Any combination that will work?
Thanks in advance!
September 2, 2010 at 5:26 pm
From everyhting I have ever been told, denys always superceed grants
September 3, 2010 at 2:16 am
More or less! 😀
I allready have my question's answer!
If inside the database I put the users associated with db_owner Role they stayed with the same permissions as "original" db_owner!
This solve my problem!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply