Databases

this group of ddl sql statements allows database administrators to manage databases database administrators can create and modify databases, including sso authentication settings you can view information about databases using the sys databases system catalog table for information on database components, see the pages on docid\ m9zbpvfqpm96jidxyhqvi , docid\ yhp4b1irv haf8f3df ww , docid\ g tzn2zxb4zp8w7za8a1k , and docid\ n7zyxmwfavae6fnmv2uvw create database create database creates a new database the database name must be distinct from the name of any existing database in the system to create a database, you must have the create database privilege for the current system syntax create database \[ if not exists ] database name true 193,101,286 unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type example create a new database named ocient create database ocient; drop database drop database removes an existing database this sql statement also disconnects all users currently connected to the database to remove a database, you must have the drop database privilege for the current database you cannot drop a database while it has any pipeline in a running status the drop database sql statement removes the existing database and all created users, tables, and views this action cannot be undone syntax drop database \[ if exists ] database name \[, ] true 193,115,272 unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type example remove an existing database named ocient drop database ocient; alter database alter database rename alter database rename renames an existing database to rename a database, you must have the alter database privilege for the database syntax alter database old database name rename to new database name true 193,193,194 unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type example rename an existing database named oracle to ocient alter database oracle rename to ocient; alter database set sso integration alter database set sso integration configures the database to authenticate using an external sso provider this sso integration is the default for connections unless you use a connectivity pool or specify a different provider to set a connection, you must be a system level user or a database administrator and have an open connection to the database this sql statement is an alias for docid\ uy5crlqbr0ymvtqzwna6x see docid\ rurudicbkdqxfu y99p1r for details about configuring sso protocols if your {{ocient}} system is version 25 0 or later, you can create multiple sso integrations for each database an sso integration assigned to the database by the alter database sql statement is the primary sso connection, unless you connect to the database with a connectivity pool that has a different sso integration assigned to it syntax alter database database alter sso integration sso name true 193,193,194 unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type example this example sets an example database to use the sso integration named sso test alter database example database set sso integration sso test; alter database alter sso integration alter database alter sso connection configures the database to authenticate using an external sso provider this sso integration is the default for connections unless you use a connectivity pool or specify a different provider to alter a connection, you must be a system level user or a database administrator and have an open connection to the database this sql statement is an alias for docid\ uy5crlqbr0ymvtqzwna6x see docid\ rurudicbkdqxfu y99p1r for details about configuring sso protocols if your ocient system is version 25 0 or later, you can create multiple sso integrations for each database an sso integration assigned to the database by the alter database sql statement is the primary sso connection, unless you connect to the database with a connectivity pool that has a different sso integration assigned to it syntax alter database database alter sso integration sso name true 193,193,194 unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type example this example alters an example database to use the sso integration named sso test alter database example database alter sso integration sso test; alter database remove sso integration alter database remove sso integration removes an existing sso integration as the default connection protocol for the database this action effectively undoes the docid\ uy5crlqbr0ymvtqzwna6x sql statement to remove a connection, you must be a system level user or a database administrator syntax alter database database remove sso integration true 193,193,194 unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type example remove the default connection from the database named example database alter database example database remove sso integration; alter database alter security sets the security settings at the database level using the alter database alter security sql statement replace \<security setting> with the security setting and \<value> with the value syntax alter database database alter security \<security setting> \[=] \<value> true 193,193,194 unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type example set the password lifetime to 20 days for the database example db alter database example db alter security password lifetime days = 20; related links docid nwuyof4 i 7wgmmmbf4j docid\ nw9vavkey2v75moxm muo docid\ jfltms91v2bfledppksy8 https //docs ocient com/system catalog