Re: How do I find I am administrator?
From: Sunny (sunny_1178_at_hotmail.com)
Date: 04/06/04
- Previous message: Martini: "QA Object Browser don´t show Databases"
- In reply to: Hari Prasad: "Re: How do I find I am administrator?"
- Next in thread: Hari: "Re: How do I find I am administrator?"
- Reply: Hari: "Re: How do I find I am administrator?"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 6 Apr 2004 15:52:52 -0500
Thanks Hari.
Since I am db_owner, why I am not able to create new store procedure, view
and table? It gives me error "CREATE TABLE permission denied in database
'myTestDB'.
Your suggestion would be great help.
"Hari Prasad" <hari_prasad_k@hotmail.com> wrote in message
news:eVNtu1$GEHA.1528@TK2MSFTNGP09.phx.gbl...
> Hi Sunny,
>
> 1.What is that means. I do not have admin rights to whole server?
>
> Based on the output you fell inside the 'db_owner' role in your database.
> This ensure that you can do any activiites inside that database.
> But you not in the part of 'SYSADMIN' role, which is the server wide
role.
> Due to that your SP_HELPLOGINS failed. This command will list the details
of
> all Logins who can access SQL server.
>
> 2.What is that means. I do not have admin rights to whole server?
>
> Yes, You have full access to only ur database.
>
> 3.Is package admin is different than server adminn?
>
> Yes, While saving the package you can mention a Owner password. That might
> be needed while accessing the exiting package.
>
> Thanks
> Hari
> MCDBA
>
>
> "Sunny" <sunny_1178@hotmail.com> wrote in message
> news:OupOe69GEHA.1368@TK2MSFTNGP11.phx.gbl...
> >
> > "Hari" <hari_prasad_k@hotmail.com> wrote in message
> > news:#CzPhl4GEHA.3772@TK2MSFTNGP12.phx.gbl...
> > > Hi,
> > >
> > > How do I find I am in admin group or not? How do I find what rights I
am
> > > given?
> > >
> > > That depends up on the type of authentication you are using to access
> SQL
> > > server. If you are normal user and you are using
> > > SQL Authentication, then you can run sp_helplogins to get all the
> > > informations;
> > >
> > > How to check:
> > >
> > > Login to query analyzer and go to the database you have prev and
execute
> > >
> > > sp_helpuser <user_name>
> > I selected MyTestDB and ran the store proc and it returns 3 records,
> > extracts from the query results:
> >
> > GroupName DefDBName
> > db_owner master
> > db_accessadmin master
> > db_ddladmin master
> >
> > I believe I have admin rights to MyTestDb.
> > > If you have admin rights then execute the below command from Master
> > > database.
> > >
> > > sp_helplogins <login_name>
> >
> > Then I selected master database and ran same sp. I got message "User
does
> > not have permission to perform this action."
> >
> > What is that means. I do not have admin rights to whole server?
> >
> > > Can I make changes on package without admin rights ?
> > >
> > > You can create packages, but you can modify the pckage with out
knowwing
> > the
> > > package admin password.
> >
> > Is package admin is different than server adminn?
> > >
> > > Is there any limitation in enterprise manager as client tools and
> > > enterprise manager on server where sql 2000 server is installed?
> > >
> > > No, there is no limitations.
> > >
> > > Thanks
> > > Hari
> > > MCDBA
> >
> > Thank you very much for providing detail information.
> > >
> > >
> > >
> > >
> > > "Sunny" <sunny_1178@hotmail.com> wrote in message
> > > news:uimzBx0GEHA.2436@TK2MSFTNGP09.phx.gbl...
> > > > This is the first time I will be using SQL server although I have
good
> > > > experience in FoxPro and ACCESS database, I have limited knowledge
of
> > SQL
> > > > server.
> > > >
> > > > We have installed SQL server 2000 on WIN2K. Our IT people has
> installed
> > > > Enterprise Manager on my win2000 workstation. How do I find I am in
> > admin
> > > > group or not? How do I find what rights I am given?
> > > >
> > > > Can I make changes on package without admin rights or do I have to
> > change
> > > > package physically from server where sql server is installed? Is
there
> > any
> > > > limitation in enterprise manager as client tools and enterprise
> manager
> > on
> > > > server where sql 2000 server is installed?
> > > >
> > > >
> > >
> > >
> >
> >
>
>
- Previous message: Martini: "QA Object Browser don´t show Databases"
- In reply to: Hari Prasad: "Re: How do I find I am administrator?"
- Next in thread: Hari: "Re: How do I find I am administrator?"
- Reply: Hari: "Re: How do I find I am administrator?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
