| Team Fly | |
This privilege allows a person to change the contents of columns in rows belonging to other tables. The SQL update statement can change the value of data in one or more columns. As with insert activity, the update transactions need to commit their work to make it permanent in the Oracle Database 10g files.
Delete operations interact with one or more rows in Oracle Database 10g tables and must be followed by a commit as well to write the results of the transaction to the database files.
We will see more in Chapter 2 about how SQL statements are constructed using the four keywords in the previous sections. SQL statements are subject to rigorous syntax requirements which, if not followed, return an assortment of Oracle errors. Just as with other programming languages you may be familiar with, the SQL statement processing engine is very strict with reserved words and the placement of the pieces that come together to form an SQL transaction. Let's briefly discuss system privileges that allow certain users of the Oracle Database 10g to perform secure activities.
We have mentioned the database administrator in a number of places in this introductory chapter. Classically, secure operations are performed by the DBAs, however one can grant system privileges to specified users so they can perform selected activities themselves. The following list illustrates a few examples of these secure operations of which we speak.
There are a number of modes within which the Oracle Database 10g can operate. The modes are toggled using the alter system command. This privilege can be given out to Jane by issuing the command grant alter system to jane;.
Often, the DBA wants to partition some of the user creation activities between a handful of users of the Oracle Database 10g. This is done by giving out the create user system privilege. Once new users are created, we often want to tweak their environment, along the lines of what we spoke about in a few places around this chapter. This can be accomplished by issuing the grant alter user statement to one or more users of the database.
Sometimes when new users are created, they are given the create session system privilege which allows them to connect to the Oracle Database 10g. In many cases, depending on how new users are created, they are not allowed to build any objects until they receive the create table system privilege. As well, many users are not capable of defining triggers until they receive the create trigger system privilege.
| Team Fly | |