Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • tracksqltime.sql Oracle
  • ORA-00064: object is too large to allocate on this O/S during startup Oracle
  • SQLPLUS COPY command Precautions. Oracle
  • This is from Temi Oracle
  • 339939.1 Running Cluster Verification Utility to Diagnose Install Problems Oracle
  • Running some SQL on multiple databases connecting using monitoring userid and password Linux/Unix
  • purge_trc.sh Linux/Unix
  • Oracle 10g Installation/Applying Patches Tips Oracle
  • How to find the real execution plan and binds used in that explain plan in Oracle 10g?? Oracle
  • My Minimum Tuning Programs Oracle
  • runon_allpdbs_show_conname.sh Oracle
  • RAC 11g with vmware Oracle
  • Optimizer_Index init.ora parameter explaination. Oracle
  • Goog notes on X$ tables Oracle
  • copying/removing directory with all its subdirectory Linux/Unix

How To Limit The Access To The Database So That Only One User Per Schema Are Connected (One Concurrent User Per Schema)

Posted on 27-May-2009 By Admin No Comments on How To Limit The Access To The Database So That Only One User Per Schema Are Connected (One Concurrent User Per Schema)

1. Set in INIT.ORA the parameter

resource_limit = true

and restart Database.

Since Oracle 9iR2 (9.2.0.1) you can perform this without restarting Database

by issuing as SYS:

alter system set resource_limit=true;

2. Connect to Database as SYSTEM or SYS and create the following Profile:

create profile single_user limit sessions_per_user 1;

The other parameters should be adjusted too, but here we discuss only

the session_per_user.

3. Create the user/schema where only one concurrent connection should be allowed

and grant other needed privileges.

create user test1 identified by test1 profile single_user;

grant connect, resource to test1;

4. Test it by trying to connecting with two users “test1”:

Session 1: connect test1/test1 -> Connected

Session 2: Connect test1/test1 ->

ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit

Oracle, SQL scripts

Post navigation

Previous Post: Default User Profile
Next Post: How to Make Trace Files Created by Oracle Readable by All Users ?

Related Posts

  • Backup and Recovery Scenarios Oracle
  • Find Plan Hash value fphv.sql Oracle
  • How to know current SID Oracle
  • Rollback force for distributed transactions Oracle
  • Monitor Long Running Job Oracle
  • New Latest Param.sql for finding all hidden parameters also Oracle

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • AMC10 (0)
  • Ansible (0)
  • AWS (2)
  • Azure (1)
  • Django (0)
  • GIT (1)
  • Linux/Unix (150)
  • MYSQL (5)
  • Oracle (403)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (18)
  • rman-dataguard (26)
  • shell (151)
  • SQL scripts (349)
  • SQL Server (6)
  • Uncategorized (9)
  • Videos (0)

Recent Posts

  • Tutornet.US — Source of excellent learning14-Oct-2026
  • OCI Infrastructure Patching14-Oct-2026
  • Free API credits for AI models14-Oct-2026
  • AMC1020-Sep-2026
  • Key Management in Oracle: The Core Issue: Missing Master Key12-May-2026
  • SAT Mathematics 10 questions and answer at the end.30-Apr-2026
  • top 10 AI news today30-Apr-2026
  • runon_allpdbs_show_conname.sh23-Apr-2026
  • runon_allcdbs_find_pdbs.sh23-Apr-2026
  • Running PDB on single node in RAC09-Apr-2026

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Standby Database Behavior when a Datafile is Resized on the Primary Database Note:123883.1 Oracle
  • How to Modify the statistics collection by MMON for AWR repository Oracle
  • RMAN : Consistent Backup, Restore and Recovery using RMAN Oracle
  • Jai Shree Ram Oracle
  • How to collect CPU usage on Linux using Shell script Linux/Unix
  • lck.sql Oracle
  • find_log_switch.sql Find log switches in graphical manner Oracle
  • DBMS_UTILITY PACKAGE Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme