Tagged Questions
2
votes
2answers
1k views
“ORA-01950: no privileges on tablespace 'SYSTEM' ” : What error is it?
Earlier I created a user :
SQL>create user suhail identified by password
SQL>User created.
SQL>Grant create session,create table to suhail;
SQL>Grant Succeeded.
but when I login as ...
0
votes
1answer
323 views
ORA-00990 error while trying to grant priviliges: Why is that? [closed]
After creating a user named suhail I am trying to grant that user some privileges. But I am getting an error saying missing or invalid privilege . Why is that ?
C:\Windows\system32>SQLPLUS / AS ...
3
votes
1answer
1k views
How to connect multiple users/schemas in Oracle 11g?
I'm almost new user to databases, so I think I'm doing something wrong.
I have the database created.
I created 3 users, 1 it's an Admin, 2 are just users.
I created 2 roles, 1 for the Admin and 2 ...
3
votes
2answers
2k views
What is the difference between ROLE and PRIVILEGE for Oracle?
Is role a collection of certain privileges?
