Method and system used for refining database authority

The invention provides a method and a system used for refining database authority. The method includes: establishing a data source table according to configuration information of a database of which the authority needs to be refined; acquiring database name information and table information and field information in the database from the configuration information to establish a resource table; creating accessing users, and storing accessing-user information to establish a user table; and establishing relationships of the accessing users and resources in the resource table according to the accessing users and the resources in the resource table, and carrying out storing to establish a user resource relationship table. According to the method, finer control authority can be realized for the database, and security of the database is improved. 本发明提供了种用于细化数据库权限的方法和系统，该方法包括：根据需要细化权限的数据库的配置信息建立数据源表；从配置信息中获取数据库名称信息及数据库中的表信息和字段信息，以建立资源表；创建访问用户，并将访问用户信息进行存储以建立用户表；根据访问用户和资源表中的资源，建立访问用户和资源表中的资源的关系并进行存储，以建立用户资源关系表。本发明可以对数据