Results 1 to 2 of 2

Thread: Dba And Sysdba

  1. #1
    Join Date
    Jan 2005

    Unanswered: Dba And Sysdba

    What's the difference between DBA role and System priviledge "SYSDBA" ?
    Thanks in advance

  2. #2
    Join Date
    Jun 2004
    Provided Answers: 1
    A role is a collection of one or more privileges; it is a way of granting privileges to groups of people without having to assign the individual privileges everytime e.g. you could create a role called "marketing" & assign all the privileges that a marketing person would need, then when you create an account for someone who works in the Marketing Dept you only have to allocate the role to his account.

    The role "DBA" is made up of the SYSTEM privileges, but with the ADMIN option included. The SYSDBA privilege allows whoever it is assigned to to do all the 'top level' things (such as create a database).
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

Posting Permissions

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