Home » RDBMS Server » Server Administration » create dimension
create dimension [message #426037] Tue, 13 October 2009 23:21 Go to next message
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 #426039 is a reply to message #426037] Tue, 13 October 2009 23:30 Go to previous messageGo to next message
Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku
Senior Member

I'd not suggest you to administer the production database without having enough experience
Re: create dimension [message #426040 is a reply to message #426039] Tue, 13 October 2009 23:33 Go to previous messageGo to next message
charuamit
Messages: 121
Registered: January 2009
Senior Member
i can't help it...as my dba z on leave fr an yr and she handed over all her work to me ....
please help me out.
Re: create dimension [message #426041 is a reply to message #426040] Tue, 13 October 2009 23:39 Go to previous messageGo to next message
Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku
Senior Member

I'd suggest you to read documentation

http://download.oracle.com/docs/cd/B19306_01/network.102/b14266/authoriz.htm#DBSEG5000
Re: create dimension [message #426043 is a reply to message #426040] Tue, 13 October 2009 23:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
charuamit wrote on Wed, 14 October 2009 06:33
i can't help it...as my dba z on leave fr an yr and she handed over all her work to me ....
please help me out.

Please read OraFAQ Forum Guide.
Do not use IM speak.
Repost in english.

Regards
Michel
Re: create dimension [message #426044 is a reply to message #426041] Tue, 13 October 2009 23:43 Go to previous messageGo to next message
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 #426046 is a reply to message #426044] Tue, 13 October 2009 23:52 Go to previous messageGo to next message
Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku
Senior Member

I'd suggest you to create a clone database and perform all your test on that database and check whether it works or not
Re: create dimension [message #426059 is a reply to message #426044] Wed, 14 October 2009 00:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Never use predefined roles, create your own
2/ Do you need these privileges? Do you need these objects?

Regards
Michel
Re: create dimension [message #426064 is a reply to message #426059] Wed, 14 October 2009 00:49 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Job Scheduling on Last Sun, Tue and Thu of every month
Next Topic: how to synchronize between tow schema separated on tow databases (merged 4)
Goto Forum:
  


Current Time: Mon Dec 05 18:57:16 CST 2016

Total time taken to generate the page: 0.11134 seconds