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
Procedures are generally executed with privileges assigned to the creator of procedure and not with the privileges available to the user executing the procedure.
Was the procedure created in dev schema? if not, the user in whose schema the procedure exists must be given privilege for the tables referenced by the procedure.