Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2013
    Location
    India
    Posts
    246

    Unanswered: Procedure execute privilege

    Hi all,

    I am using db2 10.5 on RHEL 6. I need to create 19 procedures through user1. My instance owner is SUPUSER.

    My doubt is if i create these procedures using user1 then SUPUSER will also have execute privilege on thos procs or not (as SUPUSER is SYSADM), or i need to grant execute to SUPUSER.

    Please respond its urgent.

    regards

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    if "Please respond its urgent" you need to submit this to another forum
    db2-payable-services or learn db2 from
    IBM DB2 10.1 Information Center for Linux, UNIX, and Windows
    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

  3. #3
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    you can always create a dummy procedure and check if user has execute-authority in syscat tables...
    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

  4. #4
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hi,

    If you have 'Y' for at least 1 of the columns of the following select:
    Code:
    select *
    from table(AUTH_LIST_AUTHORITIES_FOR_AUTHID('SUPUSER', 'U')) t
    where authority='DATAACCESS'
    then you don't have to grant execute privilege on procedures - DATAACCESS includes an ability to execute almost any routine.
    Regards,
    Mark.

  5. #5
    Join Date
    Sep 2013
    Location
    India
    Posts
    246
    Thanks

    problem resolved after granting DATAACCESS to instance owner.

    security model has changed in 10.5 instance owner cant access data by default

    ssumit

Posting Permissions

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