CREATE DATATYPE Permissions

[Former Member]

Hi  I am trying to extract a database to a new SQL Anywhere database for replications using SQL remote and we have some user defined data types. When it gets to updating the new database it gets a CREATE DATATYPE permissions not granted.

two questions   1) Which user is this attempting the install with ?

                         2) where do I grant these permissions. I don't see it listed under authorities anywhere ?

Thanks

Terry

[former_member182948]

Hi,

You should watch the description about the privilege of the next document.

"CREATE DOMAIN statement "

http://dcx.sap.com/index.html#sa160/en/dbreference/create-domain-statement.html

Privileges

You must have the CREATE DATATYPE or CREATE ANY OBJECT system privilege to create domains owned by you. You cannot create domains owned by others.

You can get a privilege by the GRANT statement.

ex.

GRANT CREATE DATATYPE TO UserName

Please see the following documents.

"GRANT statement"

http://dcx.sap.com/index.html#sa160/en/dbreference/grant-statement.html

"Granting a system privilege (SQL) "

http://dcx.sap.com/index.html#sa160/en/dbadmin/grant-privilege-sql.html

Regards,

Koichi

[former_member186998]

Hi Terry,

Could your question be settled by the following documents?

http://dcx.sap.com/index.html#sqla170/en/html/815123706ce210149ee4965636453aec.html

Thanks,

Atsushi