SYSTEM FOR DETERMINING DIRECT AND INDIRECT USER ACCESS PRIVILEGES TO DATABASE OBJECTS

A method and computer system are disclosed for determining the access privileges currently held by a database user with respect to objects in the database. The steps of the method are: (a) requesting a determination of those objects to which a given user has access privileges; (b) automatically determining those objects to which the user has direct access privileges; and (c) automatically determining those objects to which the user has indirect access privileges. This last step (c) is accomplished by (1) automatically determining all access groups to which the user belongs; and (2) automatically determining those objects to which those access groups, determined in step (1), have access privileges.