Access question

  • A user owns few tables in a database in SQL 2000 server. Can this user give rights to another user to access his tables?

  • Not sure what you mean, can you provide some screen shots or what error do you get when you try to query a this table? can you see it in enterprise manager for SQL server 2000, SSMS 2005 and above?

    It is possible to grand and revoke user rights based on tables, just need to understand what your issue is.

    ***The first step is always the hardest *******

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply