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