Tag: REVOKE Permission

9 Jan by dbtut Tags: , , , , , , , ,

GRANT, REVOKE and DENY Commands in SQL Server(TSQL)

You can use GRANT, REVOKE, and DENY commands on many database objects in SQL Server. With the GRANT command, you can authorize a user. With the REVOKE command, you can revoke a given authorization. With the DENY command, you can deny an authorization. In this article we will examine where we can use these commands. […]
9 Jul by dbtut Tags: , , , , , , , , ,

role “x” cannot be dropped because some objects depend on it

  If you want to delete the PostgreSQL user, we can get the error “role x can not be dropped because some objects depend on it”. You can find the display of the error below.   In order to remove the user without receiving this error, you must first revoke the user authority as follows. […]