MS SQL Server - can't insert or update row in table
Robert Eppich
RobertEppich at epsi.bc.ca
Wed Oct 10 02:22:25 EDT 2007
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
More information about the use-livecode
mailing list