Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2012
    Posts
    1

    Unanswered: SQL0552N user does not have the right privileges

    hi! I'm getting this exception when trying to execute some commands in DB2 9.7 installed on linux system. SQL0552N "INST1" does not have the privilege to perform operation "CREATE TABLESPACE". SQLSTATE=42502.

    Apparently, this user hasn't the right privileges to execute this operation. How can I give this user SYSCTRL or SYSADM authority, even if a database does not exist before running the command?

    Please suggest!

    Thank you in advance!

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    You need to add them to a group that has either of those privileges.

    Andy

Tags for this Thread

Posting Permissions

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