Question : I am hosting two different databases (manage_invite and manage_invite_v49) on the same server. As you can see, when […]
SQL Server 2019 – using MSA as a proxy account
Question : I’m thinking about using MSA (or gMSA) as proxies inside my SQL Server instances. This proxies would be […]
How to deny viewing definition of server level trigger?
Question : I have several server level triggers, that I want users to deny viewing definition of. I control server […]
User cannot create schema in PostgresSQL database
Question : I’m trying to setup a “deployment” user which can create and alter tables on an existing database in […]
Permissions needed for dbms_metadata.get_ddl in a function
Question : Oracle Enterprise 184.108.40.206 I’m receiving: ORA-31603: object “string of type “string” not found in schema “string” when executing […]
How to GRANT or DENY access to an object based on metadata for that object in SQL Server?
Question : We are in the process of reviewing our database permissions among various applications and business groups on SQL […]
select permission was denied on the object ‘sysjobs’
Question : The select permission was denied on the object ‘sysjobs’, database ‘msdb’, schema ‘dbo’. I have already tried to […]
How to test user permissions
Question : I have two server users, lets say admin and notadmin. I need to test notadmin‘s permissions. I need […]
MySQL service stops after trying to grant privileges to a user
Question : I am using MySQL 5.6, I was trying to create a super user for specific database but I […]
GRANT SELECT ON SEQUENCE succeeds, but to no effect?
Question : I am trying to grant select access to sequences from one user/role to another. There are no errors […]