Database users can access only those database objects and functions allowed by the database privileges available to them. Users acquire some privileges automatically, but you must grant, give, or assign others. Privileges can include the right to manage privileges for other users.
Database privileges are also known as a rights, access rights, or permissions.
If a user does not have the required privileges for a database request, the database denies the action, returns an error message to the user, and logs a violation in the access log.
Some row level security restrictions do not generate errors or log violations. See Using Access Logging with Row Level Security.