I am currently using Sybase Central 15.x. In which I have a database, a login and a User. Here I need to give permission(s)/role(s) to a user by which it able to extract ddl of database. There I found that if I give sa_role then user can extract ddl. But as I know sa_role make a user as a super user(sa). So I need to know that there exist any other permission/role to do the same task.
From the ASE Utility Guide; Section: ddlgen, regarding Permissions required to use
Users must have either sa_role or sso_role to generate DDL for: - Encryption keys - Logins - Roles For all other objects, users do not need any specific permissions or roles to generate DDL
Is your user receiving errors when they attempt to use
ddlgen (and if so, what errors)?