Question : I have a role engineer1 | No inheritance, Cannot login | member of {priv_app}. The priv_app user ownes […]
Category: Security
One call to `decryptbypassphrase` for decrypting all columns
Question : If I use ENCRYPTBYPASSPHRASE to encrypt the full table then how can I decrypt full table easily by […]
Group permissions in postgreSQL not inheriting to table level
Question : I am moving to a group role from a lot of individual users and have one table that […]
How to GRANT object permission to a user defined server role?
Question : I want to create logins that are granted permission to access all user databases view all definitions select […]
If I backup my Certificates, why do I need to backup the DMK?
Question : If I have a server where I use TDE, configured as follows: USE [master] CREATE DATABASE MyTDE CREATE […]
Operation level authorization in PostgreSQL
Question : I’m developing an analytics application that provides multiple levels of visualization of a data warehouse in a Postgres […]
SQl server 2008R2 Performance issue after SP3 update
Question : We have recently applied SP3 KB2979597 and Security Update Patch KB4057113 on Sql server 2008R2 but after that […]
How database administrators can see my requests to SQL Server?
Question : I’m a SQL Server 2008 user. I have access to some tables. I need to request few columns […]
Grant permissions to a user to grant select to specific tables in several schemas in Oracle
Question : I administer a small datawarehouse in Oracle. My user dwhmanager was given the SELECT ANY TABLE privilege: GRANT […]
MySQL LDAP authentication
Question : Is LDAP authentication and authorization in MySQL possible? What are the requirements (MySQL version, third-party software etc.)? How […]