Share via

mylittleadmin user and permission issue

Gulfinquiries 26 Reputation points
2021-12-01T11:42:31.353+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,351 questions
0 comments
Accepted answer
  1. Erland Sommarskog 107K Reputation points
    2021-12-02T22:27:10.78+00:00

    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.

    0 comments

7 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ronen Ariely 15,106 Reputation points
    2021-12-01T22:58:13.113+00:00

    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 :-)

    0 comments
  2. AmeliaGu-MSFT 13,971 Reputation points Microsoft Vendor
    2021-12-02T02:59:12.443+00:00

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

    154314-image.png

    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.

  3. Olaf Helper 43,246 Reputation points
    2021-12-02T06:39:33.567+00:00

    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.

    0 comments