Oracle Database 12c R2 SQL: Controlling User Access
Oracle SQL 12c
| Beginner
- 11 Videos | 37m 17s
- Includes Assessment
- Earns a Badge
Discover how to control database access to specific objects and add new users with different levels of access privileges.
WHAT YOU WILL LEARN
-
discuss the benefits of user access controldifferentiate between system and object privilegescreate a user and grant privilegesdescribe the purpose of a rolegrant privileges to a rolechange a password using the ALTER USER statement
-
list the various object privilegespass on privileges using the WITH GRANT OPTION clauseconfirm granted privilegesrevoke privileges using the REVOKE statementimplement user access control
IN THIS COURSE
-
1.Controlling User Access4m 8s
-
2.Privileges2m 7s
-
3.Granting Privileges2m 57s
-
4.Roles2m 22s
-
5.Granting Privileges to a Role2m 15s
-
6.ALTER USER Statement2m 41s
-
7.Object Privileges3m 38s
-
8.WITH GRANT OPTION clause3m 51s
-
9.Confirming Granted Privileges4m 16s
-
10.REVOKE Statement3m 25s
-
11.Exercise: Implement User Access5m 36s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.