This paper proposes an implementation for access control in SQL Server, and the technique is to improve security of the data masking technique devised for secure data warehouse since it stores the sensitive information which needs to be secure from attackers. A large number of techniques have been proposed for the same but based on analysis those techniques produce large overheads.

This technique can be implemented in database management system of any kind. By the help of proposed technique, it will get to know the behavior of access strongly based on mining process on intelligently recorded log and other metadata of respective access.