lab1-example - rem And one example that the student does...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Sheet1 Page 1 rem connecting to my main account connect mn668a/xxxx rem Spooling the results so I'll have them spool lab1 rem Example of creating User Accounts drop user Able Create user Able identified by a rem Grant access modes to Users and tables Grant Select on Student to Able rem Grant Create Session to each user Grant create session to Able rem Connect as each User and Demonstate that the user has the access as indicated in the table
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: rem And one example that the student does not have other access Connect Able/a Show user Select * from mn668a.student Update mn668a.student set status = 'FR' where studentid = 100 Sheet1 Page 2 e.g., that Able can select but not update...
View Full Document

{[ snackBarMessage ]}

Page1 / 2

lab1-example - rem And one example that the student does...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online