Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Some questions
Hi,
> 1.) Is it possible for me to display all the tables created by a user?
select * from user_tables;
select * from user_object_tables;
> 2.) Is it possible for me to show all the users who have logged in the
> server?
select * from v$session;
Andrew Protasov Received on Wed Nov 11 1998 - 01:40:17 CST