Question : I’ve been struggling for a couple of days with this now and have been trying to use this […]
Category: Permissions
PostgreSQL user permissions
Question : I have a PostgreSQL 9.3 database with the PostGIS extension backing a web application and GeoServer. I have […]
MySQL replication and master users on slave server
Question : Do the users initiating inserts on the master server also have to be on the slave with at […]
How to allow an SQL-ID to access one database through a view in another?
Question : I have 2 databases in MS-SQL Server 2012. The first database, ‘DatabaseA’, is accessed by multiple databases including […]
Oracle: how to set only some roles as not default for a user (no GUI)
Question : Scenario: I have instanceA I have instanceB I have USER1 in instanceA I have USER1 in instanceB USER1 […]
Revoke delete from table for database owner
Question : I am trying to revoke the DELETE privilege on a table for a database owner. I execute the […]
List of All Privileges Table on MySQL
Question : I’m trying to connect MySQL to an identity management (IDM) platform – goal is, to be able to […]
Adding group rights in db2 for a stored procedure
Question : I have a list of user accounts on AIX server, where the db2 database resides in. The user […]
Disallow superusers and single-user mode in POSTGRESQL
Question : I have a doubt about superusers and single-user mode. I want to restrict the access to a certain […]
Permission to select sys tables in stored procedure
Question : I have implemented the stored procedure to check if a specific [schema].[procedure] exists. CREATE PROCEDURE [BlobCheckExisting].[usp_DoesStoredProcedureExist] @schemaName varchar(128), […]