Controls operations that a user can perform on a specific object (insert data, delete data, etc.).Granted on individual database objects.Connecting to the database (Create Session), creating new tables, shutting down the database, etc.Control the operations that the user can perform within the database.Each user schema is granted specific privileges Guide to Oracle 10g.Identified by a unique username and protected by a password.Area in the database where the user’s database objects are stored.Each Oracle database user has a user schema.DML commands need to be explicitly saved or rolled back.Used to insert, view, and modify database data.DDL commands execute as soon as they are issued, and do not need to be explicitly saved Guide to Oracle 10g.Used to insert, update, delete, and view database data Guide to Oracle 10g.Used to create and modify the structure of database objects.Standard query language for relational databases Guide to Oracle 10g.Query: command to perform operation on database object.
Each user account owns database objects.An Oracle database consists of multiple user accounts.Guide to Oracle 10g Chapter 2: Creating and Modifying Database Tables Guide to Oracle 10g
0 kommentar(er)
