Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Category: Permissions
denydatawriter does not work in SQL Server
Question : I have a couple of admin roles in a SQL Server 2012. To prevent myself from changing data […]
Grant SELECT on all tables in Redshift
Question : I am trying to assign SELECT privilege to a group in Redshift. So I created a group and […]
Is it possible to set PostgreSQL roles with privileges this way?
Question : I’m trying to develop a system, and for the first time I’m using PostgreSQL. I’m trying to organize […]
Permissions for executing subscription in SSRS
Question : I’d like to execute an SSRS subscription after some ETL work run by a SSIS package that takes […]
MS SQL Express 2016 on Amazon AWS: I Can Take Database Offline but Can’t Bring It Online
Question : I can take databases offline (via GUI) but can’t bring them back online. The server details are as […]
mysql: Show GRANTs for all users
Question : MySQL’s SHOW GRANTS shows the permissions of the current user. Is there a way to log in as […]
Need help with SQL Server permissions
Question : Newbie here. I’ve got an SQL Server database, and I want to give someone permission to do almost […]
Audit MariaDB Which User Account Privileges Are Being Used
Question : I’m looking to improve the security of my MariaDB installation by better auditing the user accounts and the […]
The user specified as a definer (‘root’@’%’) does not exist
Question : I have a trigger defined as follow: USE `veeva_bi`; DELIMITER $$ DROP TRIGGER IF EXISTS veeva_bi.account_ai$$ USE `veeva_bi`$$ […]