Oracle?????????????
???????????? ???????[ 2014/4/25 10:46:39 ] ????????oracle ????? ???????
????????????
??????1?????????
????create user //????????dba???????????
????create user scott(?????) identified by tiger??????;
??????2????????
????drop user ???????
????????????????????????dba???????????????
??????3???????????????????????????????????????????cascade????????????????????????
??????4???′????????????κ?????system??sys??????丳????
???????????????????system?????
????grant connect to scott; (connect???) //??????
????grant resource to scott; //???????
???????????????
????(?????????sys??system) grant select on emp????? to scott; ??emp??????????scott
????scott??????select * from owner.emp
????(????)
????????????select??insert ??update??delete??all??create index....????????
????????? resource?????κ???????佨??
????connect
????dba:??????????????dba
???????????revoke (????????????)
????revoke select?????????? on emp????? from scott;
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11