Category "sql-grant"

Why role cannot be dropped because some objects depend on it

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

Oracle SELECT granted but still can't access table across users

Can any one see what's wrong with this: User ABC: create table def.something ( id number, ref number references def.anotherTable(id) ); create role ROUse

What does GRANT USAGE ON SCHEMA do exactly?

I'm trying to create a Postgres database for the first time. I assigned basic read-only permissions to the DB role that must access the database from my PHP scr