I am accessing a Sybase database and have created a new user using:
CREATE USER "ThisNewUser" IDENTIFIED BY "ThisNewPassword";
I then granted privleges:
GRANT ALL TO "ThisNewUser"
I used the output from this:
select 'grant all on ' + name + ' to "ThisNewUser";' from sysobjects where type = 'U' or type = 'P'
go
Looking at the results from this query, my new user has all permissions:
SELECT DISTINCT SU.name,
SP.selectauth,
SP.insertauth,
SP.deleteauth,
SP.updateauth,
SP.updatecols,
SP.alterauth
FROM SYSTABLEPERM SP
JOIN SYSUSERS SU on SU.uid = SP.grantee
ORDER BY SU.Name
When I search for all tables in the current database, I can see the tables I want:
select table_name from systable order by table_name
When I try doing a basic select query SELECT * FROM Customers, I get the error Table Customer not found
My queries work just fine if I log in as the root user, but not with my new user account. What am I missing here?
FYI, The server is running dbeng16.exe, but when I installed the Sybase Central 16 GUI to connect, I got the message that the DB version was version 10 and needed to be upgraded. I have no trouble accessing the old DB using the dbisqlc app, which has let me run all the commands on it, and I exported the DB to a new upgraded DB where I also tested, but neither situations work.