| regarding roles [message #23040] |
Wed, 13 November 2002 22:29  |
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  |
 |
Barbara Boehmer
Messages: 9104
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
