Sometimes, i alter the database mode using following scripts;
alter system enable restricted session ;
While the system running this mode, i want to allow the some users connect to the database. And i gave the restricted session privilege these users.
But these users still didn' t connect to the database.
Despite the gave this privilege, Why are you still can not sign in to the database ?
As per the document,
"In a single-instance environment without Oracle Restart, no user sessions are terminated or otherwise affected. Therefore, after placing an instance in restricted mode, consider killing (terminating) all current user sessions before performing administrative tasks."