Reg Database view

Database
Enthusiast

Reg Database view

Hi,am new to DBA....Can anybody help to create view database?
1 REPLY
Enthusiast

Re: Reg Database view

At a very high level:

(1) A view database can be created with no (or very little) perm space. (e.g. MyViewDB)
(2) Create your views as REPLACE VIEW MyViewDB.View1 AS SELECT ... FROM .... ;
(3) It will need SELECT WITH GRANT OPTION on each database that the views contained within it reference. For example, MyViewDB.View1 references MyDB1 and MyDB2. Then you will need to submit SELECT ON MyDB1 TO MyViewDB WITH GRANT OPTION; SELECT ON MyDB2 TO MyViewDB WITH GRANT OPTION;

HTH