Re: Export user DDL and privileges?

Morning Denis,


On 26/07/12 01:28, Denis wrote:

> rem script: user_cr_ddl.sql
> rem  Purpose: generate create user script with privs
> rem
> rem  Usage: user_cr_ddl <username>
> rem
> rem  Note:
> rem   If ORA-31608 encountered, it means the user does not
> rem   have grants in that category. Edit the spooled script
> rem   as ncessary

A nice script and very timely, I was just in the middle of doing my own 
one - you saved me the bother. Thanks.

I have noticed a possible bug in DBMS_METADATA though. When a user has 
quota on a tablespace, then the generation works OK, but, if the quota 
is unlimited it fails with the ORA-31608 error telling me that there are 
no tablespace quota objects. Hmmm.

I would have assumed that if they were in DBA_TS_QUOTAS that there would 
have been an "object".

Still, it's not the end of the world and I've only tried on on a 10g 
database so far.

Thanks again.

Cheers,
Norm.


-- 
Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL

Company Number: 05132767


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

Other related posts: