'System privileges' diaporamas de présentation

Managing users

Managing users. Hussam A. Halim Computer Science Department 2011. Objectives. After completing this lesson, you should be able to do the following: Differentiate system privileges from object privileges Grant privileges on tables View privileges in the data dictionary Grant roles

823 views • 68 slides

Oracle

Oracle. Creating and Modifying Database Objects. Database Objects. An Oracle database consists of multiple user accounts Each user account owns database objects Tables Views Stored programs Etc. Database Queries. Query: command to perform operation on database object Create Modify

809 views • 63 slides

Database Systems

Database Systems. Creating and Modifying Database Objects. Database Objects. An Oracle database consists of multiple user accounts Each user account owns database objects Tables Views Stored programs Etc. Database Queries. Query: command to perform operation on database object

898 views • 63 slides

Controlling User Access

Controlling User Access. Objectives. After completing this lesson, you should be able to do the following: Create users Create roles to ease setup and maintenance of the security model Use the GRANT and REVOKE statements to grant and revoke object privileges

518 views • 41 slides

DBA programming component

DBA programming component. SQL*Plus Scripting 1. Plus points: Same SQL language as in interactive mode Can test programs interactively first Includes predefined (built-in) functions Fast development possible Rapid prototyping Get results and feedback quickly No cumbersome environment

408 views • 33 slides

SECTION 5

SECTION 5. CONTROL DATABASE PRIVILEGES ??????? SECTION 5 OBJECTIVES ?????? AT THE END OF THIS SECTION, YOU SHOULD BE ABLE TO: ?????????? DEFINE PRIVILEGES ???? GRANT AND CONTROL SYSTEM PRIVILEGES ????????? GRANT AND CONTROL OBJECT PRIVILEGES ????????? CREATE AND CONTROL ROLES ???????

527 views • 32 slides

About the Presentations

About the Presentations. The presentations cover the objectives found in the opening of each chapter. All chapter objectives are listed in the beginning of each presentation. You may customize the presentations to fit your class needs.

401 views • 31 slides

Chapter 7 User Creation and Management Oracle 10 g : SQL

Chapter 7 User Creation and Management Oracle 10 g : SQL. Objectives. Explain the concept of data security Create a new user account Identify two types of privileges: system and object Grant privileges to a user Address password expiration requirements

1.01k views • 30 slides

Oracle 11g: SQL

Oracle 11g: SQL. Chapter 7 User Creation and Management. Objectives. Explain the concept of data security Create a new user account Identify two types of privileges: system and object Grant privileges to a user Address password expiration requirements

798 views • 30 slides

Administering User Security

Administering User Security. Objectives. After completing this lesson, you should be able to do the following: Create and manage database user accounts Authenticate users Assign default storage areas (tablespaces) Grant and revoke privileges Create and manage roles

451 views • 26 slides

Controlling User Access

Controlling User Access. Lecture 8. Oracle. Objectives. After completing this lesson, you should be able to do the following: Differentiate system privileges from object privileges Grant privileges on tables View privileges in the data dictionary Grant roles

481 views • 25 slides

Chapter 13 User Creation and Management

Chapter 13 User Creation and Management. User Accounts. Provide a method of authentication Can grant access to specific objects Identify owners of objects. CREATE USER Command. Gives each user a user name and password. Database Connection.

391 views • 25 slides

Controlling User Access

Controlling User Access. Objectives. After completing this lesson, you should be able to do the following: Differentiate system privileges from object privileges Grant privileges on tables Grant roles Distinguish between privileges and roles. Lesson Agenda. System privileges

353 views • 24 slides

Controlling User Access

Controlling User Access. Objectives. After completing this lesson, you should be able to do the following: Create users Create roles to ease setup and maintenance of the security model Use the GRANT and REVOKE statements to grant and revoke object privileges

291 views • 22 slides

Controlling User Access

Controlling User Access. Objectives. After completing this lesson, you should be able to do the following: Create users Create roles to ease setup and maintenance of the security model Use the GRANT and REVOKE statements to grant and revoke object privileges

275 views • 21 slides

Controlling User Access

Controlling User Access. Objectives. After completing this lesson, you should be able to do the following: Differentiate system privileges from object privileges Grant privileges on tables View privileges in the data dictionary Grant roles Distinguish between privileges and roles.

360 views • 20 slides

Roles & privileges

Roles & privileges. A user privilege is a right to execute a particular type of SQL statement, or a right to access another user's object. The types of privileges are defined by Oracle.

701 views • 15 slides

ITEC 313 Database Programming

ITEC 313 Database Programming. Bits of SQL. Objectives. Review Select Statement Creating tables Learn how to create and use Sequence View Learn how to Grant/Revoke priveleges. Syntax of SELECT. SELECT [ALL | DISTINCT] select-list FROM table-reference-list

245 views • 12 slides

DBA: Security

304 views • 12 slides

338 views • 9 slides