Top "Privileges" questions

This tag is for questions relating to the general topic of privileges, without reference to any specific operating system or application.

How to show all privileges from a user in oracle?

Can someone please tell me how to show all privileges/rules from a specific user in the sql-console?

sql oracle rules privileges
Permission denied for relation

I tried to run simple sql command: select * from site_adzone; and I got this error ERROR: permission denied for …

postgresql privileges postgresql-9.2 grant
Give all the permissions to a user on a DB

I would like to give an user all the permissions on a database without making it an admin. The reason …

sql postgresql ddl privileges grant
ORA-01950: no privileges on tablespace 'USERS'

I'm getting this error: ORA-01950: no privileges on tablespace 'USERS' I have a default tablespace and I'm able to create …

oracle privileges tablespace
How to start MySQL with --skip-grant-tables?

I locked my root user out from our database. I need to get all privileges back to the root user. …

mysql privileges
How do I get column datatype in Oracle with PL-SQL with low privileges?

I have "read only" access to a few tables in an Oracle database. I need to get schema information on …

oracle plsql ddl privileges
I can not find my.cnf on my windows computer

My computer is Windows XP. I need to find my.cnf to get all privileges back to the root user. …

mysql configuration privileges
How can I restore the MySQL root user’s full privileges?

I accidentally removed some of the privileges from my MySQL root user, including the ability to alter tables. Is there …

mysql privileges mysql-error-1045
How to view user privileges using windows cmd?

I am trying to view the user privileges using the command prompt in Windows. User account & User privileges such …

windows powershell cmd privileges wmic
Grant all on a specific schema in the db to a group role in PostgreSQL

Using PostgreSQL 9.0, I have a group role called "staff" and would like to grant all (or certain) privileges to this …

postgresql database-design roles privileges grant