| create dimension [message #426037] |
Tue, 13 October 2009 23:21  |
charuamit
Messages: 121
Registered: January 2009
|
Senior Member |
|
|
Dear friends
Our DBA is on leave and I have to handle the database till she returns back though i don't know much about it .
I need to create 52 users with the following privileges:
1. create dimension
2. Drop dimension
3. Alter Dimension
4. Materialized view
5. Materialized log view
Please help me ...do i need to write grant create dimension,drop dimension.....etc to user1 ??
I need it urgently.
Thanks And Regards.
Charu
|
|
|
|
|
|
|
|
|
|
|
|
| Re: create dimension [message #426044 is a reply to message #426041] |
Tue, 13 October 2009 23:43  |
charuamit
Messages: 121
Registered: January 2009
|
Senior Member |
|
|
i read it and i guess i will have to write :
grant connect,resource,create dimension,drop dimension,alter dimension,create materialized view,alter materialized view,drop materialized view,create materialized log view,alter materialized log view,drop materialized log view to user1;
is that okee ? i will have to write everything seperately ??
will it work then with this privileges ?? Or do i need some other privilege on them ?
thanks.
|
|
|
|
|
|
|
|
| Re: create dimension [message #426064 is a reply to message #426059] |
Wed, 14 October 2009 00:49 |
charuamit
Messages: 121
Registered: January 2009
|
Senior Member |
|
|
I will create users and grant them these privileges...yes we need these privileges and objects for Datawarehouse practicals.
please guide...is this query ok ?
grant connect,resource,create dimension,drop dimension,alter dimension,create materialized view,alter materialized view,drop materialized view,create materialized log view,alter materialized log view,drop materialized log view to user1;
z there something to make it precise as there are 55 users....and is there some other privilege that i need to grant so that they can work properly with materialized views,dimensions and materialized log views.
Thanks
Charu
|
|
|
|
| Re: create dimension [message #426100 is a reply to message #426064] |
Wed, 14 October 2009 01:59 |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Quote:please guide...is this query ok ?
See my point 1
Quote:is there some other privilege that i need to grant
Only YOU can know what privileges they need.
I doubt EVERY user needs any CREATE/ALTER/DROP privileges.
See SQL Reference to get the list of privileges and their usage.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
