Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    India
    Posts
    135

    Unanswered: How to Create new USER with DBA Privileges

    Hi

    how could I Create a new USER with DBA Privileges ! can anybody help me

    Thanx in advance.

  2. #2
    Join Date
    Apr 2002
    Posts
    56
    Log in as a user with the permission to grant DBA to a user (e.g. SYSTEM).

    Then 'create user <user> identified by <passwd> default tablespace .. temporary tablespace .. etc'

    Then 'grant dba to <user>

    You're done.

  3. #3
    Join Date
    Feb 2004
    Location
    India
    Posts
    135
    thanx edwin. It works.

Posting Permissions

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