[Oracle-l] Import Public Grants (9.2)
Smith, Ron L.
Jun 13, 2005 at 4:43 pm
I am trying to import grants made to Public for all the objects in a
schema. I have tried running a full import as SYSTEM and as the Schema
owner. Neither imports the Public grants. What am I doing wrong?
Powell, Mark D
: Public grants below to PUBLIC and not to the base object owner. You cannot import user PUBLIC so the only way to import public synonyms is as part of a full imp, full=3Dy. We usually run a imp with full=3Dy and rows=3Dn to get public objects after rebuilding a database, but you = cannot do this if you only want portions of the source db. So the solution is just to generate the create synonyms by selecting from dba_synonyms. Just add the necessary where clause to the following and a few SQLPlus
Mercadante, Thomas F (LABOR)
: I always create either a script or a procedure to both issue grants and create public synonyms. So an export/import followed by an execution of this procedure simply creates the syns and issues the grants again. I consider this a standard part of any database I manage. -----Original Message----- From: oracle-l-bounce_at_freelists.org On Behalf Of Powell, Mark D Sent: Tuesday, June 14, 2005 9:22 AM To: rlsmith_at_kmg.com; oracle-l_at_freelists.org Subject: RE: Import Public Grants (9.2) Public
Solution to "9.2 - Parallel Query Not Working"
This may be an odd question... Sun 6800 & Oracle 9.2
Upgrade: 8.1.7->9.2 on Windows
Unbreakable, my buns. Upgrade to 9.2/w2k
SPFILE Bug [RE: Where is Oracle 9.2 init.ora?]
RE: Export Dump of of Large Table (Size = 200 GB) in 9.2 & Import into 10.2?
RE: export import Speed up
Import from 7.3.4 to 9.2 differ
Replication messages after import
1 of 3
Jun 13, '05 at 4:43p
Jun 14, '05 at 9:37a
3 users in discussion
Mercadante, Thomas F (LABOR) (1)
Smith, Ron L. (1)
Powell, Mark D (1)
Groups & Organizations
site design / logo © 2022 Grokbase