Home » RDBMS Server » Server Administration » extract tablespace privilege (Linux, Oracle 10.2.0.3)
extract tablespace privilege [message #504962] Thu, 28 April 2011 09:35 Go to next message
lg123
Messages: 225
Registered: August 2008
Senior Member
I want to extract roles and privileges DDL for tablespace using dbms_metadata.get_ddl. How to do it?

Report message to a moderator

Re: extract tablespace privilege [message #504964 is a reply to message #504962] Thu, 28 April 2011 09:42 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Roles and Privileges are assigned to users.
Users are assigned with a default tablespace / quota on tablespace.

What are you exactly looking into?
And please search before posting. Most of these questions are already answered.

Report message to a moderator

Re: extract tablespace privilege [message #505557 is a reply to message #504964] Tue, 03 May 2011 15:00 Go to previous messageGo to next message
malalation
Messages: 12
Registered: April 2011
Junior Member
As far as I know, dbms_metadata.get_ddl is used for getting the DDL code used to create the object.

To get the privs and roles, you can use oracle enterprise manager or you can query some views such as dba_roles.

Report message to a moderator

Re: extract tablespace privilege [message #505561 is a reply to message #505557] Tue, 03 May 2011 15:42 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You can use dbms_metadata.get_granted_ddl

Report message to a moderator

Previous Topic: I need to import data to production database. The database details are not in tnsnames.ora.
Next Topic: database in mount mode
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 09 05:35:09 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.