Method and system for providing a default role for a user in a remote database

• US 20050050048A1
• Filed: 08/28/2003
• Published: 03/03/2005
• Est. Priority Date: 08/28/2003
• Status: Abandoned Application

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Perez, Vicki Louise
• Application Number:
  US10/653,002
• Publication Number:
  US 20050050048A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/24532 of parallel queries

Abstract

A method and system for assigning a user default role in a remote database of a database system is disclosed. The method and system comprises the steps of activating a default role for the remote database and utilizing the activated default role to access data within the remote database. Accordingly, a system and method is provided that allows a user to access a remote database via a default role. The system and method only requires that default role information be stored in a current role database structure and be accessible by a user. In so doing, a user can easily access information in the remote database through the default role. Therefore, this system is compatible and easily implemented utilizing existing parallel database systems.

Claims

1. A method for assigning a user a default role in a remote database of a database system, the method comprising the steps of:

(a) activating a default role for the remote database, and

(b) utilizing the activated default to access data within the remote database.

2. The method of claim 1 wherein the activating step (a) comprises the steps of

(a1) retrieving current role information of the remote database;

and

(a2) utilizing the current role information to allow the user to access data in the remote database based upon the default role of the remote database.

3. The method of claim 1 wherein the remote database contains tables.

4. The method of claim 1 wherein the database system comprises a parallel database system.

5. A computer readable medium containing program instructions for assigning a user a default role in a remote database of a database system, the program instructions:

(a) activating a default role for the remote database, and

(b) utilizing the activated default to access data within the remote database.

6. The computer readable medium of claim 5 wherein the activating step (a) comprises the steps of

(a1) retrieving current role information of the remote database;

and

(a2) utilizing the current role information to allow the user to access data in the remote database based upon the default role of the remote database.

7. The computer readable medium of claim 5 wherein the remote database contains tables.

8. The computer readable medium of claim 5 wherein the database system comprises a parallel database system.

9. A system for assigning a user a default role in a remote database of a database system, the system comprising:

means for activating a default role for the remote database, and

means for utilizing the activated default to access data within the remote database.

10. The system of claim 9 wherein the activating means comprises:

means for retrieving a current role information of the remote database; and

means for utilizing the current role information to to allow the user to access data in the remote database based upon the default role.

11. The system of claim 10 wherein the default role from the remote database is stored in the current database.

12. The system of claim 9 wherein the remote database contains tables.

13. The system of claim 9 wherein the database system comprises a parallel database system.