user account setup
- From: "Nguyen, David M" <david.m.nguyen@xxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 21 Jun 2004 15:59:49 -0400
I create an user account and grant "select any table" for someone to
query database tables that belongs to SCOTT schema. In order to
describe table structure that belongs to SCOTT he has to type.
SQL> describe SCOTT.tablename;
He asks me is there a way to query SCOTT object without typing "SCOTT."
in front of table name?
Also, how do I create an account and grant all SCOTT's privileges to
him? I want his account exactly to be the same as SCOTT.
Thanks,
David
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
