Question : In my database I have multiple users with SQL server authentication login and AD login. For ex: User […]
Tag: role
Oracle GRANT ROLE error [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]
Granting Select access to all tables within a specific Database in MS SQL
Question : I have a server that has multiple databases that are contained within that same server/project. I am using […]
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 […]
What is the equivalent of SQL Server’s db_datareader/db_datawriter in PostgreSQL?
Question : I’m porting an application from SQL Server to PostgreSQL. Most of this is simple as the application only […]
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 […]
Running a stored proc with execute as
Question : I’m using SQL Server 2016 I have a basic stored procedure using execute as that I would like […]
Why is MongoDB user with the only privilege as “find” able to insert and update collection?
Question : I want my user to have only find action privilege on a specific collection. However, when I create […]
PostgreSQL: access right problems
Question : I have a “production” user and database on which I want to give right access on all the […]
what is the difference between db_datareader and db_denydatawriter?
Question : I am trying to assign a SQL Server database role to a user who just needs to be […]