Home » RDBMS Server » Security » Creating schemas with different roles.
Creating schemas with different roles. [message #34879] Fri, 07 January 2005 11:27 Go to next message
Messages: 108
Registered: February 2000
Senior Member
I have a main schema with all tables and stored procedures. I need to create another test schema with same structure as main schema. If I change some data in test schema it should update main schema. Instead of duplicating tables and stored procedures in test schema is there any other way to view the tables and stored procedures from test schema and when update it will update the main schema?.

Re: Creating schemas with different roles. [message #34880 is a reply to message #34879] Fri, 07 January 2005 11:47 Go to previous message
John Smith
Messages: 25
Registered: February 2002
Junior Member
What is the purpose of the test schema then?

You could call main procs from the test schema and they will update data in main (due to definer's rights), but if you're not using code or updating data in test...
Previous Topic: user account can't access dba_data_files
Next Topic: revoke dml from owner
Goto Forum:

Current Time: Mon Aug 15 07:41:13 CDT 2022