CODEWITHSUNDEEP
sqlselectoracle11groles
Damien Cunningham
Damien Cunningham

Reputation: 25

Unable to grant select privilege to role I've created

This is my statement:

GRANT SELECT ON TABLE CATDX_OWNER.TBLAUTOSAVEDATA TO ROLE CATDX_OWNER_RPT_RL;

CATDX_OWNER is the schema name and the table name is TBLAUTOSAVEDATA, CATDX_OWNER_RPT_RL is the role I've created.

When running this, I get an error:

SQL Error: ORA-00903: invalid table name
00903. 00000 - "invalid table name"

I've also swapped the schema name and table name with the same results.

Upvotes: 0

Views: 707

Answers (1)

Littlefoot
Littlefoot

Reputation: 142713

Don't invent your own syntax. Remove both TABLE and ROLE from the GRANT statement.

GRANT SELECT ON CATDX_OWNER.TBLAUTOSAVEDATA TO CATDX_OWNER_RPT_RL;

Upvotes: 2

Related Questions