µÚËÄÕÂ
1.Êý¾Ý¿â°²È«ÐÔ¿ØÖÆ¡£
Óû§Éí·Ý¼ø±ð£º¾²Ì¬¿ÚÁî¼ø±ð£¬¶¯Ì¬¿ÚÁî¼ø±ð¡¢ÉúÎïÌØÕ÷¼ø±ð¡¢ÖÇÄÜ¿¨¼ø±ð¡£ ´æÈ¡¿ØÖÆ£º¶¨ÒåÓû§È¨ÏÞ¡£ºÏ·¨È¨ÏÞ¼ì²é¡£ ×ÔÖ÷´æÈ¡¿ØÖÆ£ºÊÚÓ費ͬ¶ÔÏó²»Í¬È¨ÏÞ¡£
Ç¿ÖÆ´æÈ¡¿ØÖÆ£ºÊý¾Ý¿âÖеÄÄÚÈÝ´øÓÐÃܼ¶±ê¼Ç£¬Ö»ÓоßÓÐÏàÓ¦±ê¼ÇµÄÓû§²ÅÄܹ»·ÃÎÊ¡£
2.ÊÚȨ¡£
ÊÚȨ£º----¶ÔÊôÐÔÁÐÊÚȨ±ØÐëÖ¸³öÏàÓ¦µÄÊôÐÔÁÐÃû¡£
grant select,insert,delete,update¡ on table Student,Sc to Óû§1,Óû§2
ÊÕ»ØȨÏÞ£º
revoke select on table Student,Sc from Óû§1,Óû§2
3.½ÇÉ«¡£
Êý¾Ý¿â½ÇÉ«ÊDZ»ÃüÃûµÄÒ»×éÓëÊý¾Ý¿â²Ù×÷Ïà¹ØµÄȨÏÞ£¬½ÇÉ«ÊÇȨÏ޵ļ¯ºÏ¡£ ´´½¨½ÇÉ«¡¢¶Ô½ÇÉ«½øÐÐÊÚȨ¡¢½«½ÇÉ«ÊÚȨ¸øÆäËûµÄ½ÇÉ«»òÕßÓû§¡¢½ÇɫȨÏÞ
µÄÊջء£
´´½¨½ÇÉ«£ºcreate role ½ÇÉ«1,½ÇÉ«2 ¸ø½ÇÉ«ÊÚȨ£º
grant select,insert¡
on table Student to ½ÇÉ«1,½ÇÉ«2
½«½ÇÉ«ÊÚȨ¸øÆäËûÓû§£º
grant ½ÇÉ«1
to Óû§1,Óû§2
ÊջؽÇɫȨÏÞ£º
Revoke select On table Student From ½ÇÉ«1
4.ÊÓͼ¡£
´´½¨ÊÓͼ£º
Create view ÊÓͼ1 As Select * From Student
Where Sdept = ¡®CS¡¯
µÚÎåÕÂ
1.Êý¾Ý¿âÍêÕûÐÔ¡£
Êý¾Ý¿âµÄÍêÕûÐÔÊÇÖ¸Êý¾ÝµÄÕýÈ·ÐÔºÍÏàÈÝÐÔ¡£Êý¾ÝµÄÕýÈ·ÐÔÊÇÖ¸¶îÊý¾ÝÊÇ·ûºÏÏÖʵÊÀ½çÓïÒå¡¢·´Ó¦µ±Ç°Êµ¼Ê×´¿öµÄ¡£Êý¾ÝµÄÏàÈÝÐÔÊÇÖ¸Êý¾Ý¿âͬһ¶ÔÏóÔÚ²»Í¬µÄ¹Øϵ±íÖеÄÊý¾ÝÊÇ·ûºÏÂß¼µÄ¡£
2.±£ÕÏÊý¾Ý¿âµÄÍêÕûÐÔ¡£