Question : what permissions do I need to give in order to achieve the above task to get users the […]
Category: Permissions
Database user permissions: GRANT VIEW DEFINITION but DENY on some object types
Question : I’m trying to figure out a combination of permissions that will allow a partner to see basic db […]
Do not have permission to use ‘dbo’ when creating a view
Question : I want to create a user with minimal required access to two databases within a server. The user […]
What is the minimum privilege required to create a full text index?
Question : I just created a full text catalog on my database. I now have a developer who needs the […]
What privileges are needed to run EXPLAIN PLAN FOR CREATE INDEX?
Question : My user can EXPLAIN PLAN FOR any query I like, but not for CREATE INDEX. I need to […]
Limit access to specific database only, and restrict access to system tables
Question : I have a user test, which can view data from the system tables such as pg_class. The idea […]
Create Temporary Access to production support
Question : We’re thinking of creating a web site where a manager can provide temporary access to a person for […]
How can I limit a user to only be able to run procs in a schema, which access another db?
Question : In a SQL Server 2012 SP2 Standard Edition instance I have a user in database A that needs […]
Access to the path ‘c:somepath’ is denied for MSSQL CLR
Question : I think this is a permissions problem, but I’m having trouble locating it. I have a group of […]
Audit Plugin on Ubuntu: CONTROL [main] Failed global initialization: FileNotOpen: Failed to open “/path” : exit status 1
Question : We use MongoDB 3.2.11 and try to enable Audit. New in version 2.6. MongoDB Enterprise includes an auditing […]