[Oracle-l] Import Public Grants (9.2)

[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?

Thanks!
Ron=20

--
http://www.freelists.org/webpage/oracle-l

Search Discussions

Discussion Posts

Follow ups

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

Related Discussions

Discussion Navigation

view	thread \| post
posts	‹ prev \| 1 of 3 \| next ›

Discussion Overview

group	oracle-l @
categories	oracle
posted	Jun 13, '05 at 4:43p
active	Jun 14, '05 at 9:37a
posts	3
users	3
website	oracle.com

font	variable	Hotkey: f
user style	avatars	Hotkey: a

[Oracle-l] Import Public Grants (9.2)

Search Discussions

Discussion Posts

Related Discussions

3 users in discussion