System versus SQL name, Part 1: Object authority and privileges for SQL database objects

When executing SQL statements you can run them either using System or SQL Naming. The System Naming conventions follow the traditional methods used on IBM i systems such as library
support. The SQL Naming mode on the other hand is defined in the SQL Standard and used by all other databases. When asking what is the difference between SQL and System Naming, you will
normally get the answer, schema and object are either separated with a slash or a period. However there are many more differences especially with regard to the access authority and
ownership of database objects created either using SQL or System Naming. This article will show the differences between SQL and System Naming primarily focusing on how the ownerships and
access authorities vary when creating DB2 for i database objects (such as tables, stored procedures or triggers) with the two naming conventions.


  • No Related Posts

Leave a Reply