Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2005
    Posts
    47

    Unanswered: Runstats Stored procedure rights.

    Hi,

    I would like to know if an application guy can run the stored procedure for runstats on his own schema and tables.Will he be able to run the SP if he has been granted CONTROL privilege on all the tables in his schema.I wanted to try this method so that he does not have to contact the DBA for a runstats on the tables.Is there also a SP for the runstats.

    Thanks
    Venky.

  2. #2
    Join Date
    Jul 2005
    Posts
    47
    I have found the solution for this post. I just found the procedure CALL SYSPROC.ADMIN_CMD('runstats on table db2user.employee on key columns and indexes all') and it requires the application people to have any of the following authorizations :
    sysadm
    sysctrl
    sysmaint
    dbadm
    CONTROL privilege on the table
    LOAD authority


    My other question is "Is there a built stored procedure for deleting data from a table without logging".

    Thanks
    Venky

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Not one that I'm aware of ..

    If the user has CONTROL priivelages on the table, you can create a stored stored procedure with the following stmts, which thay can use ;

    alter table table1 activate not logged initially with empty table
    commit
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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