Use the REVOKE
command to revoke privileges from a user.
Parameter or clause | Description |
---|---|
GRANTED BY clause | The specified user after the GRANTED BY clause must be the current user. By default, the current user is root. |
ALTER DEFAULT PRIVILEGES
command. This removes the need to revoke permissions manually for each new object.
schema1
from user user1
.
mv1
, which is in schema schema1
of database db1
, from user user1
.
s1
from user user1
.