CODEWITHSUNDEEP
sqloracle-databaserolessql-grant
Damien Cunningham
Damien Cunningham

Reputation: 25

Unable to grant role to user

I've created a role called CATDX_OWNER_RPT_RL and granted SELECT privileges on all tables within the schema. I've created a new user and granted both CONNECT, CREATE SESSION. Now I would like to assign the role I created to the new user with the following syntax - GRANT ROLE CATDX_OWNER_RPT_RL TO USER. It returns this error SQL Error: ORA-00990: missing or invalid privilege 00990. 00000 - "missing or invalid privilege"

Upvotes: 0

Views: 1151

Answers (1)

Littlefoot
Littlefoot

Reputation: 142710

Reinventing the wheel? Omit ROLE.

GRANT CATDX_OWNER_RPT_RL TO NEW_USER;

Upvotes: 2

Related Questions