Java Database Programming Bible- P13: Welcome to Java Database Programming Bible. This book is for readers who are already familiar with Java, and who want to know more about working with databases. The JDBC Application Programming Interface has made database programming an important aspect of Java development, particularly where Web applications are concerned. | Chapter 24 User Management and Database Security is important to note that the exact syntax of this command might differ as per your database. For example the following command revokes the select privileges from John Doe on the Products Table REVOKE SELECT ON PRODUCTS FROM jdoe The general syntax of this command is as follows REVOKE priv_type priv_type ON tbl_name . db_name. FROM user_name user_name . Summary In this chapter you have learned to create and manage users. Users are essential to any database system in order to regulate access to the database and to allow for granular control of the data. Furthermore you have learned about the following topics Organizing users within groups Creating and managing schemas Working with user privileges and user roles Granting and revoking these privileges or roles from users and groups Chapter 25 shows you how to tune the database for enhanced performance. -601- Team-Fly Please purchase PDF Split-Merge on to remove this .
