Table-level permissions in PostgreSQL - Cheat Sheet & Quick Revision

Recall & Review

beginner

What are table-level permissions in PostgreSQL?

Table-level permissions control what actions users can perform on entire tables, such as SELECT, INSERT, UPDATE, and DELETE.

beginner

Which SQL command is used to grant table-level permissions in PostgreSQL?

The GRANT command is used to give users specific permissions on tables.

beginner

How do you revoke table-level permissions from a user in PostgreSQL?

Use the REVOKE command followed by the permission type and the user name to remove permissions on a table.

beginner

What does the following command do? <br>

GRANT SELECT ON employees TO alice;

It allows the user 'alice' to read data from the 'employees' table but not modify it.

intermediate

Can table-level permissions be granted to roles in PostgreSQL?

Yes, permissions can be granted to roles, which are groups of users, to simplify permission management.

Which command grants a user permission to insert data into a table?

A GRANT INSERT ON table_name TO user_name;

B REVOKE INSERT ON table_name FROM user_name;

C GRANT SELECT ON table_name TO user_name;

D DROP TABLE table_name;

The GRANT INSERT command gives the user permission to add new rows to the table.

What does the REVOKE command do in PostgreSQL?

A Removes permissions from a user

B Gives permissions to a user

C Creates a new table

D Deletes data from a table

REVOKE removes previously granted permissions from a user or role.

If you want a user to only read data from a table, which permission should you grant?

A DELETE

B UPDATE

C INSERT

D SELECT

SELECT permission allows reading data without changing it.

Can you grant multiple permissions in one GRANT command?

A No, only one permission at a time

B Yes, by listing them separated by commas

C Only if the user is a superuser

D Only for SELECT and INSERT

You can grant multiple permissions by listing them separated by commas in the GRANT command.

What happens if a user has no permissions on a table?

A They can read but not write

B They can write but not read

C They cannot access the table at all

D They become the table owner

Without permissions, the user cannot access the table in any way.

Explain how to grant and revoke table-level permissions in PostgreSQL.

Think about the commands that control access to tables.

Describe why table-level permissions are important in database security.

Consider what could happen if everyone had full access to all tables.