September 28, 2007 at 7:03 am
Using the pub database through an odbc link to access i have full access to the authors table, view, delete, write.
When i create a new table i only have view permissions.
The permissions look exactly the same?
So i tried to change the permissions on the authors table and whatever you change the permsisons are as before.
We are trying to setup some simple tables that will be populated through access databases initally.
Andy
October 7, 2007 at 9:04 pm
Can you provide some more information?
When you log in through ODBC, which login do you use and what are the rights?
When you create a table, how do you do it and then how do you check permissions?
October 8, 2007 at 11:43 am
Keep in mind that for the pubs database, the guest user is enabled and has SELECT, INSERT, UPDATE, DELETE, and REFERENCES rights on all the tables. It also has the various CREATE rights. Therefore, if you're not coming in with a known user account, you're going to get the guest rights. This would explain why you can do everything with respect to any of the existing tables. If guest is creating a table, though, you should have more rights than SELECT because it would be the table owner.
K. Brian Kelley
@kbriankelley
October 9, 2007 at 1:03 am
Thanks for your help.
I believe I had the field length of the primary key too long?
The field length was to be 64 chars but I got a 2 in there somehow and so the length was 264.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply