Hi guys,
[I tried asking this in another post, but no one responded…]
I am trying to stop using the default DBA/SQL username/password on a clients Sybase 10 back-end.
In Sybase Central I have created a new user ‘servoy’ with a password.
I have given that user DBA & Resource Authorities.
I have also GRANTed ALL permissions to them on tables, BUT that user still cannot see the tables of the database!
What do I have to do to make the user just like the DBA user, but not them?
(One reason, other than good security, is that there are other processes that are accessing the back-end table and some are leaving open connections, but all are using DBA as username, so I want Servoy to have a specific username, and then do the same for the other processes so that we can see what is not closing connections properly)
Ideally, I am creating a Group in Sybase that I want to assign all these users to, and GRANT that group access to all the tables etc.
Many thanks…
Rafi