How to use profile to restrict users' resources

Editor to share with you how to use profile to limit users' resources, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's learn about it!

Create a restriction profile:

# the idle time is limited to 30 minutes

Create profile xxxx limit idle_time 30

# limit the number of sessions to 10

Alter profile xxxx limit sessions_per_user 10

# add users to the created profile:

Alter user * profile gkht_user

# View the resources limited by profile:

Select * from dba_profiles where profile='xxxx'

# View the corresponding relationship between users and profile:

Select username,profile from dba_users

Xxxx is the profile name and * user name, which can be modified as needed.

The above is all the content of the article "how to use profile to restrict users' resources". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!