+
Related Flashcards
Related Topics
Cards In This Set
| Front | Back |
|
What methods available to prevent illegal access?
|
Limit privileges to access date
Use operating-system authentication
Support third-party security software
|
|
What syntax is used to Create an account?
|
Created by using the command
CREATE USER username
IDENTIFIED EXTERNALLY;
|
|
Authenticated user means ...
|
The user has a valid account and provided the correct password.
|
|
Creating user accounts and granting privileges are generally performed by..
|
The DBA
|
|
A user name can contain...
|
Up to 30 characters, including numbers letters, and the symbols _,$, and #.
|
|
What phrase is used to create the password?
|
IDENTIFIED BY password
|
|
Temporary password
|
Can be changed by the user.
|
|
To create an account for a new employee use this syntax.
|
CREATE USER dmeyerholz
IDENTIFIED BY little25car
|
|
Syntax to connect to the Oracle Server
|
CONNECT username/password@connectstring
(the connectstring is not required on a personal edition, but is required on the Enterprise or Standard editions.
|
|
Two types of Granting privileges
|
System privileges
Object privileges
|
|
What are the Object Privileges?
|
SELECT, INSERT, UPDATE, DELETE, INDEX, ALTER, REFERENCES.
|
|
What is the difference between system and object privileges?
|
System privileges allow access to the Oracle9i database and let users perform DDL operations such as CREATE, ALTER, and DROP on database objects.
Object privileges allow users to perform DML operations on the data contained within the database objects.
|
|
How many object privileges are in Oracle 9i?
|
13
|
|
How are object privileges assigned?
|
Using the GRANT command
|
|
What is the syntax for a GRANT command?
|
GRANT {objectprivilege\ALL} [columname) objectprivilege(columname)]
ON ojectname
TO {username|rolename|PUBLIC}
[WITH GRANT OPTION];
|
