Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > Oracle
| Search | Today's Posts | Mark Forums Read
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 20th, 2005, 04:26 AM
Authorized User
 
Join Date: Jul 2003
Location: , , .
Posts: 62
Thanks: 0
Thanked 0 Times in 0 Posts
Default How to find privilege to be grant to other users?

User X put some privilege ,such as create table privilege, grant to user Y,
SQL>grant create table to Y with admin option

Then user Y secretly put create table privilege to grant to user Z
SQL>grant create table to Z

My question is how user X can find user Y put this privilege secretly to user Z?

Thanks



 
Old July 20th, 2005, 05:10 AM
_AP _AP is offline
Authorized User
 
Join Date: Jun 2005
Location: , , Russia.
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to _AP
Default

DBA_SYS_PRIVS :
System privileges granted to users and roles.

or try this
1.in INIT.ORA
AUDIT_TRIAL=DB
2.then
audit DBA by <user>/
3.then
select ,,, from DBA_AUDIT_OBJECT






Similar Threads
Thread Thread Starter Forum Replies Last Post
grant access---urgent. Komila Oracle 1 March 21st, 2007 03:57 AM
Sequence grant in Oracle rekha_jsr Oracle 1 January 3rd, 2005 12:50 AM
Problem regarding setting up Privilege Mimt MySQL 6 August 19th, 2004 04:09 PM
Urgent ! Find Online Users qazi_nomi Classic ASP Databases 1 August 17th, 2004 04:39 PM
find Intranet users mateenmohd Classic ASP Basics 0 June 12th, 2004 12:21 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.