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.
12,808 questions
0 comments
Accepted answer
  1. Erland Sommarskog 101.8K Reputation points MVP
    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. Gulfinquiries 26 Reputation points
    2021-12-02T05:47:54.353+00:00

    Thanks Amelia,Pituach,Erland and OlaHelper

    I had already raised thread in plesk forum but didn't get any reply. I will post the answer once i am thru.

    Juzer

    1 person found this answer helpful.
  2. Olaf Helper 41,001 Reputation points
    2021-12-01T11:49:25.607+00:00

    plesk panel

    Do you mean this? https://www.plesk.com/
    That's not a Microsoft product; contact Plesk support to get assistance.

    0 comments
  3. Gulfinquiries 26 Reputation points
    2021-12-01T11:58:48.763+00:00

    Yes, but i just want to know the workaround in t-sql.plesk has nothing to do. Something i am missing in SQL. Due to my limited understanding.I have another user - user2

    1. I log into that account through user2
    2. use myDatabase
    3. Select any table it runs properly
    0 comments
  4. Erland Sommarskog 101.8K Reputation points MVP
    2021-12-01T22:50:44.47+00:00

    Someone who has admin permissions need to grant your user permissions to select from the tables. Who that admin would be, I don't know.