RelationalDBDesign
SiteMap
Database Analysis
Database Design
Extended DB Features
Oracle SQL Extensions
User Profiles
«Prev
Next»
Extended Features
Partitioned Tables
Oracle Partitioning Explained
Partitioning Advantages
Table Range Partitioning
Index Partitioned Table
Local Index Partition
Global Index Partition
Modifying Partition Features
Dropping Oracle Partitions
Splitting Merging Partitions
Clustering Tables
Clustered Tables Advantages
Clustered vs Non-Clustered
Oracle Clustering Advantages
Creating Oracle Cluster
Size Cluster Properly
Creating Cluster Key
Oracle Hash Cluster
Creating Hash Cluster
Deleting Hash Cluster
Clustering Conclusion
Index Organized
Index Organized Tables
Advantages Disadvantages IOT
Creating Table Index
Allocate Overflow Space
Deleting Altering IOT
Reorganize IOT
IOT Conclusion
Auditing Features
Auditing Oracle Entities
Enable Audit Feature
Audit SQL Statement
Access Audit Trail
Oracle System Privileges
Auditing Database Objects
Purge Audit Trail
Language Support
National Character Set
Using Profiles
Product Profile
Profile Table
Limit Command Access
Security Scheme
SQL WildCards
SQL Wildcard Characters
Removing Restriction
Target Profile
SqlPlus Utility
Using Wildcards - Exercise
Implementing Restrictions
Objective:
Impose some user restrictions on COIN database users.
Exercise scoring
This exercise is worth 10 points, and will be graded on your submission to the tutor.
Background and Overview
In previous exercises, you created a COIN database and a number of users for the database. In this exercise, you will create a script that will impose some restrictions for some of the users of that database.
Instructions
Add rows to the
PRODUCT_PROFILE
table to prevent the users
BID1
and
BID2
from doing an
INSERT
, UPDATE, or
DELETE
operation with SQL*Plus.
Hints
You could use a wildcard to impose the restriction. You should make sure that your wildcard representation of the user is narrow enough to avoid interfering with other potential users. For the purposes of this exercise, you should use a separate statement for each individual SQL statement.
Submitting your exercise