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:
Average rating
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.