Question : Today I learned about GRANT REFERENCES. In years of SQL admin and dev work I never heard about […]
Category: Permissions
How to create a read-only server role on SQL Server 2012?
Question : I am granting the “View any database” permission when creating a new server role, but realized this permission […]
Execute Job With Stored Proc Signed with Certificate
Question : I’m trying to grant permissions to a user to run one job. I created a certificate, assigned it […]
Grant usage to a schema from another database
Question : In PostgreSQL, how can I GRANT USAGE to a certain schema for a certain user in a certain […]
Change built-in default privileges in PostgreSQL?
Question : Introduction. When I create a database, postgres=# CREATE DATABASE test2 OWNER test2; it is created with an empty […]
Finding AD group permissions source
Question : We have an AD group as a Login in several servers, usually as sysadmin, but I’ve found one […]
Can’t “SET TRUSTWORTHY ON” With Non-SA User Account [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]
How to retrieve granted privileges without access to the database “mysql”?
Question : As a MySQL user without access to the mysql database, is it possible to retrieve my privileges? Answer […]
SQL Server: grant select access to a user in a view and not in its tables
Question : I have a SQL Server 2012 instance with a few databases. In one of them I created a […]