Why are my tables 'read only'?
-
I am not seasoned in databases in general, let alone in MS SQL Server administration in particular. I have installed MS SQL Server 2000 on my computer - authentication set to SQL Server and Windows. My problem is, that after I have designed my database tables in an Enterprise Manager the tables appear to be 'read only' when I access them in a Query Analyzer. It doesn't help to set 'enabled' to all of the existing permissions to my database and all its tables for my account, a public and a guest. I can't append a row neither in Query Analyzer, nor programmatically. Of course I can access the database itself and its tables as well. This applies to all my databases. I know I have overlooked something in SQL Server settings, but I haven't a clue what it is. Can you give me a hint?
Regards, Zdenek
-
I am not seasoned in databases in general, let alone in MS SQL Server administration in particular. I have installed MS SQL Server 2000 on my computer - authentication set to SQL Server and Windows. My problem is, that after I have designed my database tables in an Enterprise Manager the tables appear to be 'read only' when I access them in a Query Analyzer. It doesn't help to set 'enabled' to all of the existing permissions to my database and all its tables for my account, a public and a guest. I can't append a row neither in Query Analyzer, nor programmatically. Of course I can access the database itself and its tables as well. This applies to all my databases. I know I have overlooked something in SQL Server settings, but I haven't a clue what it is. Can you give me a hint?
Regards, Zdenek
Zdenek Navratil wrote:
It doesn't help to set 'enabled' to all of the existing permissions
Including the DenyWriter permission? It would appear to me that you are logging in with different accounts in Query Analyzer and Enterprise Manager.
Upcoming Scottish Developers events: * UK Security Evangelists On Tour (2nd November, Edinburgh) * Developer Day Scotland: are you interested in speaking or attending? My: Website | Blog
-
Zdenek Navratil wrote:
It doesn't help to set 'enabled' to all of the existing permissions
Including the DenyWriter permission? It would appear to me that you are logging in with different accounts in Query Analyzer and Enterprise Manager.
Upcoming Scottish Developers events: * UK Security Evangelists On Tour (2nd November, Edinburgh) * Developer Day Scotland: are you interested in speaking or attending? My: Website | Blog
I don't think so. I run both Query Analyzer and Enterprise Manager in the same account.
Regards, Zdenek
-
I don't think so. I run both Query Analyzer and Enterprise Manager in the same account.
Regards, Zdenek
So, you can modify data in Enterprise Manager, but not in Query Analyzer? If they are running in the same account this cannot happen.
Upcoming Scottish Developers events: * UK Security Evangelists On Tour (2nd November, Edinburgh) * Developer Day Scotland: are you interested in speaking or attending? My: Website | Blog