Kbase P101721: How to grant SELECT permissions to a user?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
31/05/2005 |
|
Status: Verified
GOAL:
How to grant SELECT permissions to a user?
FIX:
The proper syntax to grant SELECT privileges to a user is:grant select ON table_name TO username
The following is an example granting SELECT privileges to user John on table pub.customer
grant select on pub.customer to John
You are only able to grant SELECT privileges on a table by table basis. In other words you can not grant a user SELECT privileges on all tables in one statement.