Grant create session to mass users
Hi pandito,
I tried your script but I was given error message saying that 'USERNAME' is invalid column name.
BBC_EMPLOYEE is a table that I have created under my schema.
Here is a snapshot of the BBC_EMPLOYEE table.
The actual table has 500 users. I wish I have only a douzen users. I can do it with runtime variable or grant privilege on per user basis.
SEQ PWD LAST_NAME FIRST_NAME
BBDD ABCF SMITH JOHN
DDPP MMTT TONY LOUIS
CCDD TTRR LOVETT AMY
RTTP PPTT DOH SAMUEL
4 rows selected
Wanted to grant CREATE SESSION to them so they can connect to the database.
Please tell me what I'm doing wrong.
Thanks for your prompt response.
Grant create session to mass users
Hi all'
I have created mass users and loaded it in a table called BBC_EMPLOYEE, all under my schema.
When I query the table
SQL> select * from BBC_EMPLOYEE;
its shows me the list of all users and the count is also right.
When I query Select * from DBA_USERS; NONE of those mass users created show up. Why? I just gave create session privilege to users and NONE of the users was able to connect.
Can someone please advise?
Thanks
Richard