Technical Development - Tiveloper.

Syntax ALTER USER user_name IDENTIFIED BY password; SQL*Plus has a PASSWORD(PASSW) command that can be used to change the password of a user when the user is logged in. This is not available in iSQL*Plus.

Syntax ALTER USER user_name IDENTIFIED BY password; SQL*Plus has a PASSWORD(PASSW) command that can be used to change the password of a user when the user is logged in. This is not available in iSQL*Plus.

What is a Role? - A role is a named group of related privileges that can be grant to the user. - A user can have acess to several roles, and users can be assigned to the same role. ex) CREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager to user1, user2;

What is a Role? - A role is a named group of related privileges that can be grant to the user. - A user can have acess to several roles, and users can be assigned to the same role. ex) CREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager to user1, user2;

CREATE SESSION : Connect to the databaseCREATE TABLE : Create tables in the user's schemaCREATE SEQUENCE : Create a sequence in the user's schemaCREATE VIEW : Create a view in the user's schemaCREATE PROCEDURE : Create a stored procedure, function, or package in the user's schema Syntax ) GRANT privilege [, privilege...] TO user [, user | role, PUBLIC...]; Current system privileges can be found ..

CREATE SESSION : Connect to the databaseCREATE TABLE : Create tables in the user's schemaCREATE SEQUENCE : Create a sequence in the user's schemaCREATE VIEW : Create a view in the user's schemaCREATE PROCEDURE : Create a stored procedure, function, or package in the user's schema Syntax ) GRANT privilege [, privilege...] TO user [, user | role, PUBLIC...]; Current system privileges can be found ..

More than 100 privileges are available.Provided by the database administrator Typical DBA privileges CREATE USERDROP USERDROP ANY TABLEBACKUP ANY TABLESELECT ANY TABLECREATE ANY TABLE

More than 100 privileges are available.Provided by the database administrator Typical DBA privileges CREATE USERDROP USERDROP ANY TABLEBACKUP ANY TABLESELECT ANY TABLECREATE ANY TABLE

Database security : - System security - Data Security DBA : A high-level user - creates users - grants users access to the database and object USER - Require system privileges to gain access to the database - Require database privilege to manipulate the content of the objects in the database. - Can be given the privilege to grant additional privilegs to other users or to roles. Schemas : A colle..

Database security : - System security - Data Security DBA : A high-level user - creates users - grants users access to the database and object USER - Require system privileges to gain access to the database - Require database privilege to manipulate the content of the objects in the database. - Can be given the privilege to grant additional privilegs to other users or to roles. Schemas : A colle..