- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: User database objects definition
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-09-2003 12:13 AM
тАО05-09-2003 12:13 AM
User database objects definition
We have a user and want to get a report about his objects including everything (tables, grants, etc).
Can we obtain it from Enterprise Manager??
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-09-2003 03:20 AM
тАО05-09-2003 03:20 AM
Re: User database objects definition
If you want to know everything taht a user have you can use user_objects view.
some description on user_obejcst
SQL> desc user_objects;
Name Null? Type
----------------------------------------- -------- ----------------------------
OBJECT_NAME VARCHAR2(128)
SUBOBJECT_NAME VARCHAR2(30)
OBJECT_ID NUMBER
DATA_OBJECT_ID NUMBER
OBJECT_TYPE VARCHAR2(18)
CREATED DATE
LAST_DDL_TIME DATE
TIMESTAMP VARCHAR2(19)
STATUS VARCHAR2(7)
TEMPORARY VARCHAR2(1)
GENERATED VARCHAR2(1)
SECONDARY VARCHAR2(1)
Hope this help
regards
mB
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-09-2003 02:31 PM
тАО05-09-2003 02:31 PM
Re: User database objects definition
To see the list of possible user views, the following will work:
select view_name from dba_views where owner like 'USER%';
Hope this helps,
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-10-2003 01:14 AM
тАО05-10-2003 01:14 AM
Re: User database objects definition
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-11-2003 06:19 PM
тАО05-11-2003 06:19 PM
Re: User database objects definition
To extract user objects definitions you can get them from Enterprise Manageger, or from quering data dictionary views or exporting like Yogeeraj said.
It depends on what type of definition you are looking for.
1. If you what just the object name, object type and date created by that particular user then you can get this from the "Enterprise Manager" report or by querying the USER_OBJECTS dictionary view. This will give the object_name, object_type (table / index / function /view /procedure /synonym...). Through Enterprise Manager, go to security panel and then users and select the options from the tool bar and then report and then this will generate report fro you. But one thing you have to remember here is you should know the type of user objects. Then you can go to the schema panel and select the type (tables / indexes / functions...) and then OPTIONS---REPORT from the tool bar and generate the report.
2. If you wanted the complete definition of the user objects like table name and the create scripts, then use the export option. The export dump will contain the complete definition of all the objects belonging to the user. Then you can do a fake inport with parameter in the import SHOW=Y and generate a log. This will give you all the craate statements of all the user objects.
I hope this helps.