Error 8200 User does not have DBSECADM authority when running CREATE TRUSTED CONTEXT
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:
GRANT DBSECADM TO dba01;