Question : Developers must not use DML and DDL commands in my company. So, I revoked their authority like update, […]
Category: Permissions
Should new roles be assigned to SYS
Question : Should the user SYS be assigned new roles beside the roles that it has when it was created? […]
SQL 2008: Why is *any* user, with minimal permissions able to restart/stop the SQL instance through Management Studio
Question : So I’m on a project that I need to help admin SQL 2008 . I’m coming from a […]
How to Deny permissions for newly created user in DDL Trigger?
Question : I’m having trouble with a SQL DDL trigger for Create_User and I’m wondering if there is an issue […]
Allowing non-privileged users to cause privileged code to run
Question : Context: Our SQL server is used for teaching, and we need to be able to automatically create databases […]
PostgreSQL Change owner of all tables under a specific schema
Question : I am trying to change the owner of all tables under the same schema in one command line. […]
mysqld: Can’t create/write to file ‘/home/mysqltmp/ibXXX’ Permission denied
Question : My main volume is a 20GB SSD disk mounted on /. I have a 4TB HDD mounted in […]
What are the minimal MySQL grants for the debian-sys-maint user?
Question : What are the minimal privileges that debian-sys-maint@localhost needs for the mysql service to work correctly? This answer on […]
SQL DATABASE ENGINE permisions
Question : I want to deny query for insert,update,delete,alter in database engine only? is there a way to do that […]
Connecting to a new RDS instance from an EC2 instance
Question : I’m trying to use MediaWiki and WP to connect to two MySQL databases. The databases are working properly […]