OC GET TABLE PRIVILEGE LIST

version 1.5

OC GET TABLE PRIVILEGE LIST (cursor_ID; table; owner_Array; grantor_Array; grantee_Array; priv_Array; grant_Array)

Parameter	Type		Description
cursor_ID	Longint		Cursor ID
table	String		Name of table
owner_Array	String		List of owner names
grantor_Array	String		List of privilege grantors
grantee_Array	String		List of grantee names
priv_Array	String		List of privileges
grant_Array	String		List of attributes that can be granted

The OC GET TABLE PRIVILEGE LIST command reports permissions on a table.

cursor_ID must be the ID of a previously created and inactive cursor.

table is the name of the table whose column information you wish to obtain.

owner_Array is the name of a string array that will accept the values of the list of owner names for the column.

grantor_Array is the name of a string array that will accept the values of the list of privilege grantors for privileges specified in priv_Array.

grantee_Array is the name of a string array that will accept the values of the list of grantee names for the privileges specified in priv_Array.

priv_Array is the name of a string array that will accept the values of the list of privileges.

grant_Array is the name of a string array that will accept the values of the list of attributes that can be granted.

The following method loads the lists of primary keys and their descriptions into arrays.

   ARRAY STRING(30;arOwn;0)
   ARRAY STRING(30;arGrantor;0)
   ARRAY STRING(30;arGrantee;0)
   ARRAY STRING(30;arPriv;0)
   ARRAY STRING(30;arGrant;0)
   OC GET TABLE PRIVILEGE LIST(cur_id;arTab{arTab};"arOwn";"arGrantor";"arGrantee";
                        "arPriv";"arGrant")