Home » RDBMS Server » Security » still same error in roles
still same error in roles [message #23071] Fri, 15 November 2002 21:30 Go to next message
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 Go to previous message
Barbara Boehmer
Messages: 8922
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.
Previous Topic: regarding roles
Next Topic: still doubt in roles
Goto Forum:
  


Current Time: Thu May 26 02:19:59 CDT 2022