mylittleadmin user and permission issue

Question

Hi,

I have created a SQL database in plesk panel along with a user. I am able to login to sql query analyzer 2000 through that user but unable to select any table. It says user does not have permission to perform this action.

Can anyone pls guide me.

Thanks
Juzer

Answer 1

I deleted the DB. Created one fresh with new user mainDR2.
I logged into sql query analyzer with mainDR2
I wrote following

1. Use MyDatabase
2. Select from Member ------- shows invalid object name member
3. Select from main.Member ------- shows all records properly

user main is coming from old database when i import in Plesk.
I am sure i am missing something silly
Even Select * into Member from main.Member works properly

I don't know if you have any experience with later versions of SQL Server, but if you have, SQL 2000 can certainly be confusing.

If you are logged as the user main and you say

CREATE TABLE Member

That table will be created in your default schema. Actually, this is true for all versions of SQL Server. But what is weird in SQL 2000 and earlier version is that your default schema is always your username and this cannot be changed. Or more specifically: on SQL 2000 owner and schema was the same, and we never talked about schema in those days.

Best advice: stay away from SQL 2000.

Answer 2

As others mentioned this forum is own by Microsoft and it's for discussions about Microsoft products and Microsoft services.

What you do, is like stopping a bus and ask him about where is the taxi or vice versa

I did a 2 second search in Google and found this forum, where you should ask the question probably
https://talk.plesk.com/

I hope that this help you :-)

Answer 3

Hi Gulfinquiries-5150,
Welcome to Microsoft Q&A.
Please check the Plesk support article which might be helpful:

If you have more questions about Plesk, you can open a thread in the Plesk forum as others have mentioned.

Best Regards,
Amelia

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 4

I am able to login to sql query analyzer 2000

Plesk really hands out SQL Server Query Analyser 2000?? Boah!
That's really more then out-of-support.