CODEWITHSUNDEEP
sqloracle-database
Med.Fathallah
Med.Fathallah

Reputation: 1

Oracle - restrict user access to only one connection

I have installed Oracle SQL Developer 11g and I have created many connections and I try to create user which will have access on only one specified connection

How can i do that?

Upvotes: 0

Views: 469

Answers (1)

user330315
user330315

Reputation:

You need to create a profile that limits the number of sessions:

create profile only_one_connection
   limit sessions_per_user 1;

Then you need to alter the user and assign that profile to the user:

alter user only_one 
   profile only_one_connection;

This assumes you have already created the user only_one and granted the create session privilege. You can also assign the profile when creating the user

Upvotes: 1

Related Questions