USA: +1 725-224-8795 
Sign in
This question comes from Database and Concepts 7th edition ISBN Number 978-0-13-3544626 If you have not already implemented the Garden Glory database shown in Chapter 3 in a DBMS product, create and populate the GG database now in the DBMS of your choice (or as assigned by your instructor). A.Create a user named GG-User with the password GG-User+password. Assign this user to database roles so that the user can read, insert, delete, and modify data. B.If you haven’t completed Exercise 7.50, do it now. C.Add a new folder to the DBC website named GG. Create a web page for Garden Glory in this folder—using the file name index.html. Link this page to the DBC web page. D.Create an appropriate ODBC data source for your database.
Expert Answer
A. Create a user named GG-User with the password GG-User+password. Assign this user to database roles so that the user can read, insert, delete, and modify data.
Creating user:
CREATE USER GG-User IDENTIFIED BY GG-User+password
Assigning roles :
GRANT SELECT, INSERT, UPDATE, DELETE ON tableNames TO GG-User;
Here our table is employee
GRANT SELECT, INSERT, UPDATE, DELETE ON GG.dbo.EMPLOYEE TO GG-User;
The permission granted for different users can be seen by right clicking on the table and select properties , click on permissions.
c.) Add a new folder to the DBC website named GG. Create a web page for Garden Glory in this folder—using the file name index.html. Link this page to the DBC web page.
After creating Folder create html file with .html extension and write anchor tag in file as
<html>
<body>
< a href=’index.html’> Link to index page</a>
Some more contents etc
<body>
<html>
d.) Create an appropriate ODBC data source for your database.
There are diff ways to create data source on different Operating Systems here is example for windows
To add an ODBC data source
- Choose the Administrative Tools icon from the Windows Control Panel.
- Choose the Data Sources shortcut.
- In the ODBC Data Source Administrator dialog box, click Add, then select the driver you want from the Installed ODBC Drivers list and choose OK.
- In the Setup dialog box, set option values as necessary and choose OK.
