Question : I have two users A and B. I want to grant B the permission to create, drop, etc. […]
How the sys user gets the sysdba privilege?
Question : I am using oracle 12c on Linux. Using the enterprise manager database express I am looking at the […]
What could trigger that a login created from a certificate is not visible in metadata
Question : I am trying to create a login and grant it rights to run and unsafe assembly but the […]
Is a Named Instance more Secure than the Default Instance?
Question : I realize that you can change the default instance from the default port of 1433, and equally you […]
Is it good practice to assign a system account for database owner?
Question : I can see the owners of my databases usign this query SELECT name , SUSER_SNAME(owner_sid) FROM sys.databases What […]
clusterdb stopped working for PostgreSQL database in Ubuntu 12.04 server
Question : After a fresh PostgreSQL install (version 9.2) on my Ubuntu server 12.04, clusterdb utility stopped working. I used […]
Postgres RLS: how to error instead of ignoring rows not matched by the policy? [duplicate]
Question : This question already has an answer here: Log occurrences when Row Level Security Policies filter out rows (1 […]
Allow access for localhost and named server
Question : I’m trying to set up a user to allow them access from localhost and from a specific named […]
Searching transaction logs for changes
Question : I currently have a database with an attached CMS. The CMS has about 50+ people with various permission […]
Assembly deployment with permission UNSAFE or EXTERNAL_ACCESS using asymmetric key
Question : When we are trying to deploy an assembly with PERMISSION_SET=UNSAFE or EXTERNAL_ACCESS, we are getting following error message […]