Question : What is the difference between these two “Connect SQL” permissions in SQL Server 2012? Answer : While I […]
Category: Permissions
Deny certain user from updating certain rows [duplicate]
Question : This question already has an answer here: SQL Server Row by Row Access (1 answer) Closed 2 years […]
MySQL Add/Grant user if it does not exist
Question : I am trying to create a update/install script that adds a user and database only if it’s a […]
template for creating functions in the master database
Question : I need to create functions in the master database, and I am developing a template for that, I […]
Oracle GRANT ROLE error [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]
User Permissions Messed Up following a Backup -> Restore Operation
Question : I had to move several SQL Server 2008 databases to our new db server so I backed them […]
Dropping everything in a database owned by a certain role — not working
Question : I want to delete everything in a certain database owned by a certain role. I’ve tried to do […]
Possible to CREATE EVENT NOTIFICATION with a different owner?
Question : We are in the process of removing a previous dba login and he owns all the endpoints and […]
How to grant SQL Agent proxy to a public role in MSSQL 2014
Question : I want to grant SQL Agent proxy to a public role in msdb database in MSSQL 2014. I […]
Can I not add VIEW SERVER STATE to a role?
Question : My server admin asked me to grant a user SA privileges for the purpose of upgrading our vCenter […]