on 08-20-2013 11:25 AM
Hi Rupendra,
Try the following:
Grant select on schema <SCHEMA> to _SYS_REPO with grant option;
Grant select on schema <SCHEMA> to <USER>;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rupendra,
Using which user you have created schema WORKSHOPX_02. Check whether SYSTEM has select privilege on this schema.
Open Security folder --> users --> double click on 'system'
Now in SQL privileges, check you have this schema added with at least 'select' privilege.
If not run the below sql statement to give access.
GRANT SELECT ON WORKSHOPX_02 to SYSTEM;
Regards.
Venkat
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.