![]() ![]() System privileges-A sys tem privilege is the right to perform a particular action, or to perform an action on any schema objects of a particular type. There are two main type s of user privileges: When creating a user, you grant privileges to enable the user to connect to the database, to run queries and make updates, and to create schema objects. When you dro p (delete) a user, you must either first drop all the user's schema objects, or use the cascade feature of the drop operation, which simultaneously drops a user and all of his schema objects. (The EMPLOYEES table is owned by HR.) The terms database object and schema object are used interchangeably. ![]() For example, HR.EMPLOYEES refers to the table named EMPLOYEES in the HR schema. The schema name is the same as the user name, and can be used to unambiguously refer to objects owned by the user. ![]() ![]() A schema is a logical container for the database objects (such as tables, views, triggers, and so on) that the user creates. When you create a user, you are also implicitly creating a sch ema for that user. A user account is identified by a user name and defines the user's att ributes, including the following:ĭefault temporary tablespace for query processing work space ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |