IBM Support What's New?

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

Technote (troubleshooting)


Problem(Abstract)

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

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

Cause

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:
GRANT DBSECADM TO 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: 2012-12-14