Friday, 19 March 2010

Using Oracle Profile

First of all alter the system or edit the parameter file for this entry
Alter system set resource_limit = true
After that create a profile with the required options
Assign these profiles to the users whoever you want to restrict

Create profile test_profile
Limit session_per_user 2
idle_time 2 ;

Assign this profile to users

Alter user scott
Profile test_profile;

No comments:

Post a Comment