| how to give full access to other schema [message #551051] |
Sun, 15 April 2012 02:38  |
mrdb
Messages: 62
Registered: December 2009
Location: dubai
|
Member |
|
|
hi,
I want to get clear with one thing yesterday i installed oracle9i and dev 2000 to my client.
when they run one report they got stuck with pl/sql compilation errorrep-1247
when i checked that report in the report builder, in the query they are using some other table which is not belongs to that schema,
then I give that schema.tablename and compiled, but this is coming for other reports also, then only i came to know that they are acceessin other schema also, how can i sort this out.
can i fix this by givin full access privilige or what privilige can i give to get full access of other schema table.
how can i check in the old database what are all the roles and privileges given to this user,
kindly send me the query.
thanks,
|
|
|
|
|
|
|
|
|
|
|
|
| Re: how to give full access to other schema [message #551179 is a reply to message #551146] |
Mon, 16 April 2012 01:51  |
mrdb
Messages: 62
Registered: December 2009
Location: dubai
|
Member |
|
|
Thanks sharma i got that using this query sql>SELECT * FROM DBA_SYNONYMS
WHERE TABLE_OWNER ='table_owner_name' AND OWNER='PUBLIC';
normally when we are exporting a particular schema and importing it, this type of synonyms are not importing, so using the above query i checked and mannually created those synonym for the tables.
The idea given by Mr.Watson. thanks you so much.... Mr.Watson
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
