Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2008
    Posts
    131

    Question Unanswered: direct and indirect authority

    hi all,
    1.what is direct and indirect authority.
    2.what difference does each make and where this difference can be felt?

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    "direct" are authorizations that were given to you as a user.
    "indirect" are authorizations that you have based on your memberships to groups where the groups have certain authorizations.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Jul 2008
    Posts
    131
    well consider as an example,when i run the command 'db2 get authorizations' it shows:
    Direct SYSADM authority = NO
    InDirect SYSADM authority =YEs
    and all other authorities are set to 'NO'.
    in this case what all are the things i am allowed to perform.

  4. #4
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Since you have SYSADM authority, you can do whatever SYSADM is allowed to do.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  5. #5
    Join Date
    Jul 2008
    Posts
    131
    but stolze from where i got this indirect access.....while providing authorities it never ask u for direct or indirect kind of stuff....

  6. #6
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    maybe you are part of sysadm group defined for this database
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.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
  •