"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>

> If you have admin rights then execute the below command from Master
> database.
>
> sp_helplogins <login_name>

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

>
>
>
>
> "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?
> >
> >
>
>

"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?
>
>

"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?
> > > >
> > > >
> > >
> > >
> >
> >
>
>

"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?
> > >
> > >
> >
> >
>
>

"Sunny" <sunny_1178@hotmail.com> wrote in message
news:eiDTikBHEHA.324@tk2msftngp13.phx.gbl...
> 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?
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>