GRANTING PRIVELEGES -SYNTAX

[cm80]

Hi
I am developing an Oracle database and I am trying to grant another user on one of my tables but keep getting an error.

The syntax I am using is as follows:

GRANT SELECT ON tablename TO username [IDENTIFIED BY 'password']

I tried it without the square brackets and single quotes but that didn't make any difference.

Do I have the wrong syntax?

Thanks,
cm80

 

[nme]

Just try:

GRANT SELECT ON tablename TO username;

that should be it - it is better to grant these to roles though, then just grant the role to a user.


What good is a cake if you can't eat it????