-
unable to create Repositary in Designer 9i
hello all
i downloaded Oracle 9i DEveloper Suite, and installed it. When i try to open Designer, it asks to enter a userid , pwd, and conect string.
i did create one user 'rbc' on DB 'heat'. so when i enter the stuff, it says, " This user doesnot have an installed repositary. invoke the repositary administrator utility".
I then, opened the REpositary Administrator utility, and key in the same info like userid ..etc, it gets in.
Then i click on Install in Install/upgrade/migrate section, it asks me to select Repositary installation options, where only one option is highlighted which is " support for Oracle designer objects". when i select that, and go to next screen, it asks if u want to create any public synonyms, and i said yes, it next gives me a screen to pick the table space.
here it blows up !!!. it says "ERROR you donot have select privileges on v_$parameter View. This process cannot proceed "
Can anyone help in creating a repositary for Designer !!!
Thanks
Ron
-
Log on in the database where the ropository will be as SYS. Then
GRANT SELECT ON V$PARAMETER TO RBC;
after that the repository manager will want a select privilege on another view(cant remember its name now), and after you grant select on it too, you will not have problem instaling the repository
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
|