Home » RDBMS Server » Security » regarding roles
regarding roles [message #23040] Wed, 13 November 2002 22:29 Go to next message
sha
Messages: 84
Registered: July 2002
Member
Hi,
I want to create a role and assign to user.
For e.g. I create a role and assign create session and create table system privileges to it.
Then I had assigned the role to a user.When I am creating the table it is giving an error.
ORA-01950: no privileges on tablespace 'SYSTEM'
What should I do?I also want to restrict the user by only select and update statements.How do I assign this object privileges to role?I also want to know about profiles.What are they and how are they used?some e.g. of it.
thanx in advance
regards,
Shastri
Re: regarding roles [message #23070 is a reply to message #23040] Fri, 15 November 2002 19:04 Go to previous message
Barbara Boehmer
Messages: 9077
Registered: November 2002
Location: California, USA
Senior Member
In order to be able to create tables and so forth, users need tablespace access too. I find the simplest way to accomplish this is to:

SQL> GRANT RESOURCE TO username;

-- or:

SQL> GRANT RESOURCE TO rolename;

The specific privileges can be granted in the same manner, using:

SQL> GRANT SELECT ON tablename TO username; -- or rolename

-- and

SQL> GRANT UPDATE ON tablename TO username; -- or rolename
Previous Topic: regarding profiles
Next Topic: still same error in roles
Goto Forum:
  


Current Time: Thu Mar 28 03:37:15 CDT 2024