| still same error in roles [message #23071] |
Fri, 15 November 2002 21:30  |
sha
Messages: 84
Registered: July 2002
|
Member |
|
|
Hi ,Still getting the same error.
Not able to create a table.
I have created a role and assigned.connect and resource roles to it.
Then I created a user and assigned the role to it and trying to create a table.Still getting insufficient privileges.
create role r1;
grant connect,resource to r1;
create user a identified by password;
grant r1 to a;
connect a/password;
create table t1(id number(1),name varchar2(10));
I am getting this error.
ERROR at line 1:
ORA-01950: no privileges on tablespace 'SYSTEM'
thanx in advance.
regards,
shastri
|
|
|
|
| Re: still same error in roles [message #23072 is a reply to message #23071] |
Fri, 15 November 2002 22:04  |
 |
Barbara Boehmer
Messages: 9088
Registered: November 2002
Location: California, USA
|
Senior Member |
|
|
There are some things that have to be granted directly, rather than through roles. It looks like maybe CONNECT and RESOURCE are some of those things. When I try what you posted, I get the same results, but if I try granting CONNECT and RESOURCE to USER a directly, rather than granting them to ROLE r1 and granting r1 to a, it works (see test below). Sorry to have misled you previously. I should have tested first.
SQL> CREATE USER a IDENTIFIED BY password
2 /
User created.
SQL> GRANT CONNECT, RESOURCE TO a
2 /
Grant succeeded.
SQL> CONNECT a/password
Connected.
SQL> CREATE TABLE t1
2 (id NUMBER (1),
3 name VARCHAR2 (10))
4 /
Table created.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
