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

Thread: user for all schema

  1. 01-15-2009, 10:35 AM #1
    midora
    midora is offline Member
    Join Date
    Aug 2008
    Posts
    123

    user for all schema

    Hi all,

    How can i create user in oracle 9i which can hase select right on all tablespace and tables?

    Thanks
    Pat
    Reply With Quote Reply With Quote
  2. 01-15-2009, 11:49 AM #2
    LKBrwn_DBA's Avatar
    LKBrwn_DBA
    LKBrwn_DBA is offline Senior Advisor
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Any table?

    Code:
    Grant SELECT ANY TABLE To TheUser;
Grant SELECT ANY DICTIONARY To TheUser;
-- And/Or --
Grant SELECT_CATALOG_ROLE To TheUser;
    Last edited by LKBrwn_DBA; 01-15-2009 at 11:53 AM.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width