152.Examine the command:

用户锁定效果解析

今年我18

于 2016-08-06 12:11:08 发布

阅读量643

点赞数

CC 4.0 BY-SA版权

分类专栏： 1z0-052 文章标签： 1z0-052

本文链接：https://blog.youkuaiyun.com/dwj19830118/article/details/52135529

1z0-052 专栏收录该内容

187 篇文章

订阅专栏

本文解析了数据库中用户锁定命令的效果，特别强调了被锁定用户不能登录系统这一关键点，并指出其他用户仍能访问被锁定用户所拥有的对象，只要他们有相应的访问权限。

152.Examine the command:

SQL> ALTER USER skd ACCOUNT LOCK;

Which two statements are true after the command is executed? (Choose two.)
A.The SKD user cannot log in to the database instance.
B.The objects owned by the SKD user are not accessible to any user.
C.The other users can access the objects owned by the SKD user, on which they have access.
D.The password for the SKD user expires and the user is forced to change the password at the next log in.
答案：AC
解析：
A:正确，用户锁定了，该用户肯定是无法登陆系统了
B:错误，只是锁定了用户，并不是用户下的对象
C:正确
D:错误，用户锁定和密码过期是两个概念，对应的语句也是两个
alter user username identified by password --修改密码
alter user username account unlock; --解锁
alter user username identified by hr account unlock; --我们也可以一行