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
-
4m 8sIn this video, find out how to discuss the benefits of user access control. FREE ACCESS
-
2m 7sIn this video, learn how to differentiate between system and object privileges. FREE ACCESS
-
2m 57sIn this video, you will learn how to create a user and how to grant privileges. FREE ACCESS
-
2m 22sUpon completion of this video, you will be able to describe the purpose of a role. FREE ACCESS
-
2m 15sLearn how to give privileges to a role. FREE ACCESS
-
2m 41sDuring this video, you will learn how to change a password using the ALTER USER statement. FREE ACCESS
-
3m 38sUpon completion of this video, you will be able to list the various object privileges. FREE ACCESS
-
3m 51sTo find out how to pass on privileges using the WITH GRANT OPTION clause. FREE ACCESS
-
4m 16sLearn how to confirm privileges that have been granted. FREE ACCESS
-
3m 25sLearn how to revoke privileges using the REVOKE statement. FREE ACCESS
-
5m 36sFind out how to implement user access control. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.