I am using PostgreSQL 10.4 and I found a strange behavior. If we create an role and grant it to CONNECT the database: CREATE ROLE dummy; GRANT CONNECT ON DATABASE test TO dummy; Then we cannot dro...

I'm trying to make restricted DB users for the app I'm working on, and I want to drop the Postgres database user I'm using for experimenting. Is there any way to drop the user without having to rev...

Database "mydb" is owned by role "mydb_owner". User "currentuser" tries to delete role "roletodelete" from this database using revoke all on all tables in schema public,firma1 from "roletodelet...

What is the difference between the DENY and REVOKE commands in SQL Server?

How do I revoke all privileges for a user in SQLPlus? I'm logged in as sysdba and I would like to revoke all privileges for a regular user. I googled this query REVOKE ALL PRIVILEGES, GRANT OPTION ...