Db2

 View Only
Expand all | Collapse all

{"ERROR [08004] [IBM] SQL30060N \"USER01\" does not have the privilege to perform operation \"EXCSAT\". SQLSTATE=08004\r\n"} IBM.Data.Db2.DB2Exception

  • 1.  {"ERROR [08004] [IBM] SQL30060N \"USER01\" does not have the privilege to perform operation \"EXCSAT\". SQLSTATE=08004\r\n"} IBM.Data.Db2.DB2Exception

    Posted Tue September 26, 2023 05:23 PM

    Hi everyone, I'm using the net.ibm.data.db 7.0.0.2 driver (c# environment) to connect on i5/OS vers. 7R3 .. when i try to open a connection,  I get the error in the subject with any user I use (with qsecofr profile too).

    the test code is very simple:

    DB2ConnectionStringBuilder buildConf = new DB2ConnectionStringBuilder();

    buildConf.UserID = ConfigurationManager.AppSettings["user"]; 
    buildConf.Password = ConfigurationManager.AppSettings["psw"];
    buildConf.Server = ConfigurationManager.AppSettings["server"];
    buildConf.Database = ConfigurationManager.AppSettings["db"];

    string ConnectionString = buildConf.ConnectionString;

    DB2Connection conn = new DB2Connection(ConnectionString);

    conn.Open();
    conn.Close();
    conn.Dispose();

    Anyone have any suggestions?

    #Db2 for i/os



    ------------------------------
    max inter
    ------------------------------


  • 2.  RE: {"ERROR [08004] [IBM] SQL30060N \"USER01\" does not have the privilege to perform operation \"EXCSAT\". SQLSTATE=08004\r\n"} IBM.Data.Db2.DB2Exception

    IBM Champion
    Posted Tue September 26, 2023 05:41 PM

    Posting multiple copies of the same question does not warrant replies.



    ------------------------------
    Jan Nelken
    ------------------------------