Hello All,
I have been able to get access to MS SQL Server via ODBC and Mac OSX.
I can read anything I want and do SELECTS without problems, however,
I now wish to INSERT and UPDATE rows in tables.
I have tried the following:
revExecuteSQL dataBaseID, "insert into EMPLOYEE (FIRST_NAME) values
('Robert')"
the following message is returned:
INSERT permission denied on object 'EMPLOYEE', database 'EBBO',
schema 'dbo'.
I then checked my privileges by:
select * from information_schema.table_privileges where table_name =
'EMPLOYEE' or table_name = 'LABOURTICKET'
which returned the following:
dbo REPICK EBBO dbo EMPLOYEE SELECT NO
dbo REPICK EBBO dbo LABOR_TICKET SELECT NO
I read this as the user REPICK is only allowed to SELECT records and
not allowed to INSERT new records or UPDATE existing records. Am I
correct in my understanding? How can I change this from SELECT to
UPDATE?
Thanks
Robert Eppich
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
