Oracle DBA - which privilege has to be given to users to select data dictionary?

GeekInterview.com > Certification > Oracle > Oracle DBA

Go To First | Previous Question | Next Question

Oracle DBA | Question 364 of 366

which privilege has to be given to users to select data dictionary?

Total Answers and Comments: 3

Last Update: November 20, 2007 Asked by: balu

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

January 20, 2006 16:49:30

Mukesh

RE: which privalage has to be given to users to select...

Grant Select_Catalog_role to user.

Is this answer useful? Yes | No

January 17, 2007 05:25:05

harry2007

Member Since: January 2007 Contribution: 1

RE: which privalage has to be given to users to select...

You can also use grant select any dictionary to <user>; but this shall give more privileges to users so it is better to : GRANT SELECT_CATALOG_ROLE To <user> instead.

Is this answer useful? Yes | No

November 20, 2007 06:53:01

Mohammed Abdul Afroze

RE: which privilege has to be given to users to select...

Sql>grant select_catalog_role to user;

This is the Privilege to users to select the data dictionary.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank