Browse Prior Art Database

A method to auto detect the database privileges the database users require

IP.com Disclosure Number: IPCOM000238043D
Publication Date: 2014-Jul-29
Document File: 3 page(s) / 108K

Publishing Venue

The IP.com Prior Art Database

Abstract

This disclosure presents a method to auto detect the database privileges the database users require when they do some database operations, like executing a batch of database scripts.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 53% of the total text.

Page 01 of 3

A method to auto detect the database privileges the database users require


1. Summary

This invention is going to auto detect the database privileges that the database users require, so the database administrator could better know of that and assign the privileges as appropriate.


2 Problem Statement

Considering the case that when a database user or operator has to do some database operations , like executing a batch of database scripts.


• He/she will probably encounter the problem of lack of some privilege, that he/she has to go to the administrator;

• The administrator could assign that certain privilege to the user;

• The user may encounter the problem of lack of another privilege, that he/she has to go to the administrator again;
• The administrator could assign the privilege to the user for the second round;

• #

• It may keep a bunch of rounds until the database scripts could run all successfully ;

3

3
Our method Our method

This present invention is going to provide an open interface of the database system which would determine the user permission for the SQL operations and return with any of the required privileges. The interface will have the database scripts as the input and then output with the required privileges. Using that output the database administrator will be able to know the required privileges and then decide whether to assign them.

3


3.

..111 Advantages

Advantages

• User could easily know which execution privileges the database scripts require;

• The privileges could be simplified so the result would make more sense to the end user ;

3


3.

.....