11/10/2022 0 Comments Db2 json query example![]() If the global variable is defined inside the module, then the user should have the DATAACCESS privilege over the schema which has a module in which the variable is defined.If the global variable is defined inside the module, then the user should have the EXECUTEIN privilege over the schema which has a module in which the variable is defined.If the global variable is defined inside the module, then the user should have the EXECUTE privilege over the module in which the variable is defined.If the global variable is not defined inside the module, then it should have the READ privilege over it.If we have any of the expression which is global in nature being used in the query then the user or object with authorization id should have one of the specified privileges or authorities from the following: User should have the privilege of CONTROL over the view on the table which is identified.Īlong with one of the above privileges, a user must also possess the DATAACCESS authority.User should have the privilege of DataAccess on the schema of view or table.User should have the privilege of SELECTIN on the schema of the view or table. ![]() ![]() ![]() User should have the privilege of SELECT on the view or table.When a user or object with a certain authorization id is trying to use the query he must have certain privileges which include at least one of the privileges mentioned in the below-given authorities.Ī user should have at least one of the following authorities when working on one of the identified tables or views. Hadoop, Data Science, Statistics & others ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |