Securing Database Resources › Securing Access to Non-SQL-Defined Databases › SQL Access to a Non-SQL-Defined Database

SQL Access to a Non-SQL-Defined Database

With the CA IDMS SQL Option, a user can access a non-SQL-defined database using SQL. If the database is secured, you allow SQL access to a non-SQL database by creating an SQL schema for a non-SQL schema (this requires CREATE privilege on the SQL schema, USE privilege on the non-SQL schema) and granting table access privileges to other users.

Note: For more information, see the following sections:

• Securing SQL schemas
• Securing Non-SQL-defined Schemas