# US 2016/0253494 A1 · Dynamically differentiating service in a database based on a security profile of a user

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2016/0253494 A1
- Document ID: US20160253494A1
- Status: Published application
- Kind: A1
- Application number: 15/093,626
- Filed: 2016-04-07
- Published: 2016-09-01
- Earliest claimed: 2005-01-06
- Assignees: Oracle International Corporation
- Applicants: Oracle International Corporation
- Inventors: Nithya Muralidharan; Daniel ManHung Wong
- Web page: https://patentgrep.com/patent/US20160253494A1

## CPC

- G06F 21/55: Detecting local intrusion or implementing counter-measures
- G06F 16/122: {using management policies (point-in-time backing up or restoration of persistent data G06F11/1446; file migration policies for HSM systems G06F16/185)}
- G06F 16/335: Filtering based on additional data, e.g. user or group profiles (filtering in web context G06F16/9535, G06F16/9536)
- G06F 2221/034: Test or assess a computer or a system
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

One embodiment of the present invention provides a system that differentiates service provided to a database user based on a security profile of the user. During operation, the system receives a sequence of commands from a user at a database system. The system then uses the sequence of commands to determine a security profile which indicates whether the user is behaving suspiciously. Next the system associates a resource consumer group with the user based on the security profile. Finally, the system differentiates service provided to the user based on the resource consumer group.

## Claims

### Claim 1

A method for differentiating service based on a security profile of a user, the method comprising:
receiving a sequence of database commands from a user at a database server in the database system;
determining command information from the database commands, wherein the extracted command information includes at least a table or a column accessed by the database commands;
applying pre-specified rules to the command information to determine a security profile, which involves determining whether the access to the table or column matches criteria for suspicious behavior, wherein the security profile indicates a level of suspicious activity for the user;
based on at least the level of suspicious activity for the user, differentiating services provided to the user's session by performing at least one of:
decreasing the amount of processor time that the user is allowed to utilize to be below a percentage of processor time determined by the security profile; and
migrating the user's session to a database instance for suspicious sessions.

### Claim 2 (depends on 1)

The method of claim 1, wherein determining the security profile involves determining a set of database tables or a set of database columns that are accessed while executing the sequence of commands.

### Claim 3 (depends on 1)

The method of claim 1, wherein determining command information involves analyzing the sequence of database commands prior to execution of the sequence of database commands.

### Claim 4 (depends on 1)

The method of claim 1, wherein determining command information involves analyzing the sequence of database commands after executing a command in the sequence of database commands.

### Claim 5 (depends on 1)

The method of claim 1, wherein differentiating service provided to the user can involve changing the auditing level for the user.

### Claim 6 (depends on 1)

The method of claim 1, wherein differentiating service provided to the user can involve:
differentiating service for a current session associated with the user; or
differentiating service for a future session associated with the user.

### Claim 7 (depends on 1)

The method of claim 1, wherein determining the security profile involves continually updating the security profile based on the user's behavior.

### Claim 8

A computer-readable storage medium storing instructions that when executed by a computer cause the computer to perform a method for differentiating service based on a security profile of a user, the method comprising:
receiving a sequence of database commands from a user at a database server in the database system;
determining command information from the database commands, wherein the extracted command information includes at least a table or a column accessed by the database commands;
applying pre-specified rules to the command information to determine a security profile, which involves determining whether the access to the table or column matches criteria for suspicious behavior, wherein the security profile indicates a level of suspicious activity for the user;
based on at least the level of suspicious activity for the user, differentiating services provided to the user's session by performing at least one of:
decreasing the amount of processor time that the user is allowed to utilize to be below a percentage of processor time determined by the security profile; and
migrating the user's session to a database instance for suspicious sessions.

### Claim 9 (depends on 8)

The computer-readable storage medium of claim 8, wherein determining the security profile involves determining a set of database tables or a set of database columns that are accessed while executing the sequence of commands.

### Claim 10 (depends on 8)

The computer-readable storage medium of claim 8, wherein determining command information involves analyzing the sequence of database commands prior to execution of the sequence of database commands.

### Claim 11 (depends on 8)

The computer-readable storage medium of claim 8, wherein determining command information involves analyzing the sequence of database commands after executing a command in the sequence of database commands.

### Claim 12 (depends on 8)

The computer-readable storage medium of claim 8, wherein differentiating service provided to the user can involve changing the auditing level for the user.

### Claim 13 (depends on 8)

The computer-readable storage medium of claim 8, wherein differentiating service provided to the user can involve:
differentiating service for a current session associated with the user; or
differentiating service for future sessions associated with the user.

### Claim 14 (depends on 8)

The computer-readable storage medium of claim 8, wherein determining the security profile involves continually updating the security profile based on the user's behavior.

### Claim 15

An apparatus for differentiating service based on a security profile of a user, the apparatus comprising:
a receiving mechanism embedded in a computer system configured to receive a sequence of database commands from a user at a database server in the database apparatus;
a determining mechanism embedded in the computer system configured to:
determine command information from the database commands, wherein the extracted command information includes at least a table or a column accessed by the database commands; and
apply pre-specified rules to the command information to determine a security profile, which involves determining whether the access to the table or column matches criteria for suspicious behavior, wherein the security profile indicates a level of suspicious activity for the user;
the determining mechanism further configured to determine whether the security profile for the user corresponds to a high level of suspicious activity; and
a differentiation mechanism configured to differentiate services provided to the user's session, based on at least the level of suspicious activity for the user, by performing at least one of:
decreasing the amount of processor time that the user is allowed to utilize to be below a percentage of processor time determined by the security profile; and
migrating the user's session to a database instance for suspicious sessions.

### Claim 16 (depends on 15)

The apparatus of claim 15, wherein the determining mechanism is configured to determine a set of database tables or a set of database columns that are accessed while executing the sequence of commands.

### Claim 17 (depends on 15)

The apparatus of claim 15, wherein the determining mechanism is configured to analyze the sequence of database commands prior to execution of the sequence of database commands.

### Claim 18 (depends on 15)

The apparatus of claim 15, wherein the determining mechanism is configured to analyze the sequence of database commands after executing a command in the sequence of database commands.

### Claim 19 (depends on 15)

The apparatus of claim 15, wherein the differentiating mechanism is configured to change the auditing level for the user.

### Claim 20 (depends on 15)

The apparatus of claim 15, wherein the differentiating mechanism is configured to:
differentiate service for a current session associated with the user; or
differentiate service for future sessions associated with the user.
