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.YOU MIGHT ALSO LIKE
Channel
Oracle RAC
Channel
Wintellect SQL Server