Oracle and SQL Server Database System Based on Role Access Control Comparative Analysis

摘要

Security of the database is extremely important for the entire information security, access control technology- is an effective way to ensure security of the database, access control database security- management of important mechanisms are role and permission assignment Firstly, general RBAC model and control through the formal process of representation, research access control method based on role, then research each of Oracle role-based access control and role-based access control SQL Server, finally, comparative analysis of Oracle and SQL Server database system based on the role access control. The results show that, Oracle's role and authority is complex, SQL Server is relatively simple, if you require a higher security of the database is recommended to choose Oracle, if the DBA's skill level is general, recommends that select SQL Server.