This Article will cover below points:
- How to create DB View in Microsoft SQL Server.
- How to provide permissions to DB View.
- How to export DB View to .sql file.
How to create DB View in Microsoft SQL Server:
Connect MS SQL Server to Siebel DB.
Expand the Siebel DB and navigate to Views
Right click on Views and Select New View..
This might take few minutes on first use and it will open below new window from where you can create db view by selecting Table, Views etc. But I prefer to write query and directly use.Click on Close button.
On Close you can see a new query window with three sections.
- 1st section will show the table/ view relational diagram.
- 2nd section will show the Columns and their details.
- 3rd window will have the SQL query.
Copy and Paste the SQL query in 3rd section and click on other section, MS SQL Server will auto create the relation diagram and populate the Column details.
From the top tool bar click on Save button and MS SQL Server will ask for DB View name, provide the appropriate name and click on OK button.
Now go to the View and right click. From the menu click on Refresh and find your newly created DB View.
How to provide permissions to DB View:
If you run SELECT query you receive permission error. To overcome this right click on DB view and Select Properties.
From the Properties window click on Permission page. From this click on Search button. In new Select User or Role window type [SSE_ROLE] in Object name field and click OK button. Now click OK button on Properties window and re run the SQL query.
How to export DB View to .sql file:
Right click on DB View name. From the menu click on Script View as > CREATE To > File.
From the new window select the location where you want to save the .sql file. Provide the File Name and click on OK. All Done.
See Also:
Comments
Post a Comment