Pls00157 authid only allowed on schemalevel programs an authid clause was specified for a subprogram inside a package or type. This is the default and creates a definers rights package. The authid clause is allowed only in the header of a standalone subprogram, a create type statement, you can include either. Specify definer to indicate that the package executes with the privileges of the owner of the schema in which the package resides and that external names resolve in the schema where the package resides.
Pretty sure a new package would be needed since the authid can only be specified at the package level to the best of my knowledge anyway. Specifying the privileges for a subprogram with the authid clause to implement invokers rights, use the authid clause, which specifies whether a subprogram executes the current user. Authid only allowed on schemalevel programs answer guest. Oracle linux is free to download and use, and i assume a great number of deployments will never be counted. Software interview questions artificial intelligence. It can only be defined in the package specification. Authid only allowed on schemalevel programs share improve this answer. An authid or default collation clause was specified for a subprogram inside a package or. Normally, when user a owns a package procedure function and grants execute access on that object to user b, when user b executes the code, the code runs with user as privileges. Begin backup records execute immediate create table schemaname. An authid clause was specified for a subprogram inside a package or type. Only schemalevel programs allow accessible by sql the accessible clause is not valid in the package body.
1282 538 649 482 1177 828 1004 311 280 152 153 771 1475 1441 698 888 147 848 599 1209 3 1541 460 574 293 982 358 1219 905 559 1320 820 195 1481 823 946 394 1000 596 519 862 621 153 1211 378 858 250 260 482 613