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;

Rate this page:

(0 users)Average rating

Add comments

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

Translate my page

Machine Translation

Content navigation