A developer is trying to create a view and the database won’t let him. He has the "developer" role which has the "create view" system privilege and select grants on the tables he is using, what is the problem?
No Answer is Posted For this Question
Be the First to Post Answer
What are the daily activities of oracle dba?
Describe hit ratio as it pertains to the database buffers. What is the difference between instantaneous and cumulative hit ratio and which should be used for tuning?
When using oracle export/import what character set concerns might come up? How do you handle them?
What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?
What are the different responsibilities of a dba?
What are the types of locks in database?
A developer is trying to create a view and the database won’t let him. He has the "developer" role which has the "create view" system privilege and select grants on the tables he is using, what is the problem?
What skills do you need to be a database administrator?
What is the most common database language that a db administrator needs to know?
What does the no logging option do? Why would we be careful of using it?
What do you understand by the term 'system change number (scn)'?
What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?