CODEWITHSUNDEEP
oracle-database
abhinav
abhinav

Reputation: 57

oracle schema - to be shared within same DB

Recently i imported a db which has multiple users , i have loads of compilation errors in packages because they want to access tables of other users , now i want someone to help me in making all the tables/procedures ... in differecnt users accessible to all users , Please not all the users have been made as DBA

What could be the command to make all users data public ?

Primarily there are 3 users who want accessibility within themselves

Please note that i am using oracle 10 G

Upvotes: 0

Views: 99

Answers (1)

maialithar
maialithar

Reputation: 3123

So, you want to grant privileges to all users's object, right?

This answer should help you: Grant Select on all Tables Owned By Specific User (answer covers only tables, but you can extend it to views, procedures, synonyms, functions, packages, ...)

Upvotes: 1

Related Questions