Hp web site - 328 Part III . Administration In my time
328 Part III . Administration In my time as a database administrator, I ve most frequently used the USAGE macro to initially create the user and then gone back and granted individual privileges for the user at a later time. With the USAGEmacro the user will be added to the grants database as normal except no privileges will be given to the user. The USAGEmacro can be helpful if the actual database hasn t been created yet (or tables haven t been created within the database). As you can see by the syntax listing, the GRANT statement accepts wildcards for the database and also wildcards within the database context to indicate all tables. For example, to grant privileges on a specific table within a database, you can use databasename.tablename (or simply tablename if you are in the database at the time). Contrast this with granting privileges on all tables within a database (which you call with the databasename.*syntax, or simply with *from within the database). Also, granting privileges to all databases and tables is possible with the use of the *.*wildcard syntax. Examples of these grants are shown in Figure 12-17. Figure 12-17: Examples of GRANT statements in differing scenarios With the GRANTstatement you can specify that the privilege will only apply to certain columns within a given table. You can also specify more than one privilege within a statement and apply that to the same or different columns within the same table or database.tablestructure. In addition, you can give the same privileges to multiple users at the same time if you separate the users/host/passwordportions with commas. Examples of these grants are shown in Figure 12-18.
Go visit our java server pages services for a reliable, lowcost webhost to satisfy all your needs.