From oracle-l-bounce@freelists.org Mon Jun 21 14:57:31 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i5LJvGS27754 for ; Mon, 21 Jun 2004 14:57:26 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i5LJv6627739 for ; Mon, 21 Jun 2004 14:57:16 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5507372C821; Mon, 21 Jun 2004 14:40:53 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 12805-80; Mon, 21 Jun 2004 14:40:53 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9634272C4C3; Mon, 21 Jun 2004 14:40:52 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 21 Jun 2004 14:39:24 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 211C772C7CB for ; Mon, 21 Jun 2004 14:39:22 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 12727-49 for ; Mon, 21 Jun 2004 14:39:21 -0500 (EST) Received: from triton.xo.com (plasmlprd04.pla.dc.xo.com [205.158.160.114]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 62D1A72C848 for ; Mon, 21 Jun 2004 14:39:21 -0500 (EST) Received: from ilchicsimr002.mail.inthosts.net ([172.19.22.42]) by triton.xo.com (Switch-3.1.5/Switch-3.1.0) with ESMTP id i5LK0NLl024702 for ; Mon, 21 Jun 2004 15:00:38 -0500 (CDT) Received: from ilchicvexc002.mail.inthosts.net ([172.19.22.16]) by ilchicsimr002.mail.inthosts.net with Microsoft SMTPSVC(5.0.2195.5329); Mon, 21 Jun 2004 16:00:31 -0400 X-MimeOLE: Produced By Microsoft Exchange V6.0.6487.1 Content-Class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain Subject: user account setup Date: Mon, 21 Jun 2004 15:59:49 -0400 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: user account setup Thread-Index: AcRXyk8v5NzvUP/+S9yddEQIjWzPCQ== From: "Nguyen, David M" To: X-OriginalArrivalTime: 21 Jun 2004 20:00:31.0564 (UTC) FILETIME=[682768C0:01C457CA] X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 3243 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: david.m.nguyen@xo.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------