-
Hi,
I am trying to create a materialized view and it is giving me insufficient privileges.
SQL> /
create materialized view testview
*
ERROR at line 1:
ORA-01031: insufficient privileges
I have assigned the following roles to the user
Resource, Connect and DBA all of them with admin option. Also I have assigned the create any view to the user and it still does not seem to work.
Any Ideas Why????
Thanks
Anurag
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|