DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: create new user

  1. #1
    Join Date
    Jul 2002
    Posts
    228

    create new user

    Hi,
    I've create a new user: (oracle 8.1.7.0 O.S. win 2000)
    connect system/manager@dboracle

    create user ora
    identified by tree
    default tablespace
    temporary tablespace temp;

    grant connect, resource to ora;

    grant select any table to ora;

    grant select_catalog_role to ora;

    grant create public synonym to ora;

    Now how Can user ora see all objects (view, table, procedure, package.....) of user ora1??

    regards
    Raf

  2. #2
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    look at the grants which you have granted to ora..
    Last edited by Sameer; 11-07-2002 at 11:24 AM.

  3. #3
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    Code:
    SQL*Plus: Release 8.1.6.0.0 - Production on Thu Nov 7 17:15:37 2002
    
    (c) Copyright 1999 Oracle Corporation.  All rights reserved.
    
    
    Connected to:
    Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
    With the Partitioning option
    JServer Release 8.1.6.0.0 - Production
    
    appdev@NICK>create user nosey identified by nosey;
    
    User created.
    
    appdev@NICK>grant create session to nosey;
    
    Grant succeeded.
    
    appdev@NICK>@conn nosey/nosey
    Input truncated to 15 characters
    nosey@NICK>select * from scott.emp;
    select * from scott.emp
                        *
    ERROR at line 1:
    ORA-00942: table or view does not exist
    /* well it does he just can't see it! */
    
    
    nosey@NICK>@conn appdev
    Enter password: 
    Input truncated to 15 characters
    appdev@NICK>grant select any table to nosey;
    
    Grant succeeded.
    
    appdev@NICK>@conn nosey/nosey
    Input truncated to 15 characters
    nosey@NICK>desc scott.emp
     Name                                                  Null?    Type
     ----------------------------------------------------- -------- ------------------------------------
     EMPNO                                                 NOT NULL NUMBER(4)
     ENAME                                                          VARCHAR2(10)
     JOB                                                            VARCHAR2(9)
     MGR                                                            NUMBER(4)
     HIREDATE                                                       DATE
     SAL                                                            NUMBER(7,2)
     COMM                                                           NUMBER(7,2)
     DEPTNO                                                         NUMBER(2)
    
    nosey@NICK>@conn appdev
    Enter password: 
    Input truncated to 15 characters
    
    
    appdev@NICK>drop user nosey;
    
    User dropped.
    
    appdev@NICK>
    Last edited by Tarry; 11-08-2002 at 04:46 AM.
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Tarry, you've missed the point of the question (IMHO). Sure, "GRANT SELECT ANY TABLE" gives him the ability to see any table, but the question was:
    Now how Can user ora see all objects (view, table, procedure, package.....)
    So the main poit here is on other type of objects, not just tables!

    Well, the answer is: Raf, you are wrong. He can't realy use those non-table objects of other users, at least not all type of them. I mean he can't execute their procedures, functions, packages, he can't use their sequences... He can select from their tables and views, he can also use their private synnonym, though - GRANT SELECT ANY TABLE gives him that power.

    But if by "how Can user ora see all objects " you mean how can he see all those objects from database dictionary, well, in that case the answer is pretty simple - GRANT_SELECT_CATALOG role enables him to do that, so nothing strange here.
    Last edited by jmodic; 11-07-2002 at 02:51 PM.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  5. #5
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    Jurij,
    You're my hero & You're very right there.
    I am aware of that catalog role I was merely diplaying the any table grant thing.

    Darn, Right now I'm deleting some 50 garbage spam, I got one also from Jeff, and lot of a naresh(dunno who this retard is) with lots of virus's. I better edit that post or else it'll keep me busy all day fighting spam.
    Last edited by Tarry; 11-08-2002 at 04:43 AM.
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width