Controlling access to database

• US 20020156782A1
• Filed: 04/19/2001
• Published: 10/24/2002
• Est. Priority Date: 04/19/2001
• Status: Abandoned Application

• Current Assignee: Micron Technology, Inc.
• Original Assignee: Micron Technology, Inc.
• Inventors: Rubert, Amy L.
• Application Number:
  US09/838,547
• Publication Number:
  US 20020156782A1
• Time in Patent Office: Days
• US Class Current: 707/9
• CPC Class Codes: G06F 21/6227 where protection concerns the structure of data, e.g. records, types, queries

Abstract

A method and apparatus are provided for controlling access to a database. The apparatus comprises a storage unit and a controller communicatively coupled to the storage unit. The controller is adapted to store a relationship between at least a first form and a second form of the database in the storage unit and to store a user access name to access the database in the storage unit, the access name having an associated user access level for accessing the database. The controller is further adapted to allow access to the database based on the relationship and the user access name at the user access level.

Claims

1. An apparatus, comprising:

a storage unit; and

a controller communicatively coupled to the storage unit, the controller adapted to;

store a relationship between at least a first form and a second form of a database in the storage unit;

store a user access name to access the database in the storage unit, the access name having an associated user access level for accessing the database; and

allow access to the database at the user access level based on the relationship and the user access name.

2. The apparatus of claim 1, wherein the controller is further adapted to associate the relationship with the user access name.

3. The apparatus of claim 1, wherein the controller is further adapted to define the user access level in a profile, wherein the profile is associated with the user access name.

4. The apparatus of claim 3, wherein the controller is adapted to define access in the profile to selected fields in at least one of the first and second forms.

5. The apparatus of claim 4, the access name having an associated access identification number, wherein the controller is adapted to store the access name and the associated access identification number in the storage unit.

6. The apparatus of claim 5, wherein the controller is adapted to store the user access name and the associated access identification number within a table in the storage unit.

7. The apparatus of claim 5, wherein the controller is adapted to allow access to the first form and second form of the database based on the user access name stored in the table.

8. The apparatus of claim 1, wherein the database is Oracle database.

9. The apparatus of claim 8, wherein the controller is adapted to store a responsibility identifier of the Oracle database in the storage unit.

10. An article comprising at least one machine-readable storage medium containing instructions for controlling access to a database, the instructions when executed enable a processor to:

store a task flow between at least a first form and a second form of the database in a storage unit;

store a user access name to access the database, the access name having an associated user access level for accessing the database; and

allow access to the database at the user access level based on the task flow and the user access name.

11. The article of claim 10, wherein the instructions when executed enable the processor to associate the task flow with the user access name.

12. The article of claim 10, wherein the instructions when executed enable the processor to define the user access level in a profile, wherein the profile is associated with the user access name.

13. The article of claim 12, wherein the instructions when executed enable the processor to associate an access identification number with the user access name and store the access name and the associated access identification number in the storage unit.

14. The article of claim 13, wherein the instructions when executed enable the processor to store the user access name and the associated access identification number within a table in the storage unit.

15. The article of claim 14, wherein the instructions when executed enable the processor to allow access to the first form and second form of the database based on the user access name stored in the table.

16. The article of claim 13, wherein the instructions when executed enable the processor to define access in the profile to selected fields in at least one of the first and second form.

18. The method of claim 17, wherein allowing access to the database comprises allowing access to one or more forms that are accessible through the database.

19. The method of claim 18, comprising identifying the received user access name from a file based on the determined access identification number.

20. The method of claim 19, comprising creating a profile that defines the user access level and associating the profile with the user access name.

21. The method of claim 20, comprising creating the profile that defines access to selected fields in at least one of the forms that are accessible through the database.

22. The method of claim 20, comprising accessing the profile based on identifying the received user access name.

23. The method of claim 17, wherein receiving the access name comprises receiving a responsibility identifier in Oracle database.

25. The apparatus of claim 24, wherein the controller is adapted to allow access to one or more forms that are accessible through the database.

26. The apparatus of claim 25, wherein the controller is adapted to further identify the received user access name from a file based on the determined access identification number.

27. The apparatus of claim 26, wherein the controller is adapted to create a profile that defines the user access level and associating the profile with the user access name.

28. The apparatus of claim 23, wherein the interface comprises a network interface.

30. The apparatus of claim 29, wherein the controller is further adapted to define a task flow between the form and another form of the database.

31. The apparatus of claim 30, wherein the controller is adapted to allow access to the database based on the task flow and the access defined in the profile.

32. The apparatus of claim 29, wherein the interface comprises a network interface.

17. A method comprising:

receiving a user access name, the user access name having an associated user access level for accessing a database and having an associated access identification number;

determining the access identification number associated with the received user access name; and

allowing access to the database at the user access level in response to determining the access identification number associated with the received user access name.

24. An apparatus, comprising:

an interface; and

a controller communicatively coupled to the interface, the controller adapted to;

receive a user access name from the interface, the user access name having an associated access identification number and having an associated user access level for accessing a database;

determine the access identification number associated with the received user access name; and

allow access to the database at the user access level in response to determining the access identification number associated with the received user access name.

29. The apparatus, comprising:

an interface; and

a controller communicatively coupled to the interface, the controller adapted to;

receive a responsibility identifier having an associated responsibility identification number and an associated profile, the profile defining access to at least one field of at least one form of a database;

receive a request to access a form of the database;

determine the responsibility identification number of the received responsibility identifier; and

allow access to the form based on the access defined in the profile and in response to determining the responsibility identification number of the received responsibility identifier.

33. An article comprising at least one machine-readable storage medium containing instructions for controlling access to a database, the instructions when executed enable a processor to:

receive an access name, the access name having an associated access identification number;

access a profile based on the access name and the associated access identification number, wherein the profile defines user access to the database; and

allow access to the database based on the user access defined in the profile.