IBM Support

Error 8200 User does not have DBSECADM authority when running CREATE TRUSTED CONTEXT

Technote (troubleshooting)


You run the CREATE TRUSTED CONTEXT command but get this error:

8200: User (dba01) does not have DBSECADM authority.


A user must have DBSECADM authority to successfully run CREATE TRUSTED CONTEXT.

Resolving the problem

A database security administrator (DBSA) uses the GRANT DBSECADM statement to give database security administrator authority to a user.

    Note: You must be a DBSA to grant DBSECADM.

Grant the DBSECADM role by issuing the GRANT DBSECADM statement.

The following statement gives DBSECADM authority to user dba01:

Document information

More support for: Informix Servers

Software version: 11.7, 11.70

Operating system(s): AIX, HP-UX, Linux, Solaris, Windows

Reference #: 1620595

Modified date: 14 December 2012