I have to create an another oracle database in my solaris server, which has one more data base running with out any issues.
Already I had created the existing data base as root user. Now i have to create one more database for testing purpose, so that i had created new database( called Sectest) through dbassist as Oracle user.
This data base created sucessfully, and also created admin user, developer user.
I gave grant permissions connect, resource, dba to dba user, and created development role .
The following previllages assigned to Development role.
Create any procedure, create procedure,
Select any table, Insert any table, update any table,
delete table, execute any procedure, alter any procedure,
select any sequences, create any triger, alter any index, create session
And then assigned Development role to dev user.
Now i had create tables, and also public synonym for those tables.
But the time of excuting my procedures in dev user, oracle gives an error as the table must be declared, even though tables are listing out when i gave describe command in dev user.
Becuase of this i am struggling to reslove this issue.
So please i need your to slove this problem.
Thanks in advance.
And i aslo i need more clarification in .profile part..
Palani Kumar. R
mail me to
You Can Win, if u believe Yourself
From that information it seems to me that there is a confusion problem with the schemas you are using.
To resolve this issue I would see what happens if you prefix the table names in your statements with the appropriate schema name ( such as [schema].[tablename] ).
Click Here to Expand Forum to Full Width