Command To Grant Sysadmin To The User

what is the command to grant sysadmin to the user?

thanks

View Replies


ADVERTISEMENT

How To Grant Sysadmin Permission To SQL Server User ?

Hi,

I'm trying to run the Bulk Insert statement but in order for me the run it, i need to have the sysadmin permission. Can someone show me how to grant sysadmin permission to my SQL Server user? This is really urgent. Thank you in advance.

View Replies View Related

What Command Is Used To Get Back The Privileges Offered By The GRANT Command?

reply.

View Replies View Related

Grant Command

hi to all,

can anyone tell me what is differences between take ownership and control permission in sql server 2005?

thank you
honey sachdeva

View Replies View Related

Way To Show User Name When They Are Sysadmin

Is it possible to show the user name (such as 'phuser') who is a member of the sysadmin group (NOT my idea!) I notice if you go to current connections is SQL EM the name shows, but if I login as that user if I try, user, user_name, etc inside of QA it shows DBO

View Replies View Related

Grant Permission On More Than One Table In A Single Command

Hi

Does anyone know how i can grant select permission on more than one table in the same database using a single grant commmand....its painful to use grant statement seperately on each table

thanks and regards,
reshma

View Replies View Related

Cannot Set Job Alerts On Notifications Tab If A Non-sysadmin User

Platform: Win2000 SP3, SQL 7.00 - 7.00.1063I have a SQL-authenticated user with the following permissions:"Process Administrators" server role"db_owner" and "TargetServersRole" for msdb database"db_owner" for master database.The problem is that when this user opens up any job (i.e. owned by anyuser) in the SQL Server Agent, and goes to the Notifications tab, thefirst three alerts (Email, Page and Net send) are greyed out, i.e.these cannot be set.The other options are available (Write to Windows application eventlog, Automatically delete job).The only way I can achieve this is to give this user the "SystemAdministrators" server role, i.e. sa.But this of course gives absolutely full access, which I don't want.Is there a way for a user to see/change Notifications of jobs whichonly he owns?

View Replies View Related

Allowing Non Sysadmin User To Send Email With Attachments

i am aware that only sysadmin can send attachments using sp_send_dbmail. but the problem is, i don wan my application login to have sysadmin role and wan it to be able to send email with attachments using sp_send_dbmail. i'm using a stored procedure to call sp_send_dbmail, anyway can i impersonate sysadmin inside the stored procedure to execute sp_send_dbmail?

 

any suggestion will be appreciated. thanks.

View Replies View Related

Sql User Grant.

so here i go explaining my problem: I create an empty database. then I use the .net aspregsql tool to make the tables and the procs and everything, and it does. when i view my database it has the 11 empty tables the sprocs and the roles and everything. BUT when I open up the "asp website configuration" to add some users, it gives the following error:EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database 'masfeni_fakebetsdb', owner 'dbo'. 

View Replies View Related

Grant All Privileges To A User

Is it possible to grant all privilege for all tables of a specified database through script? Because i have to send the script to user side and i can't do it manually in Enterprise Manager.regards,

View Replies View Related

Can I Grant All Privilege To User?

it is possible to grant all privilege (CRUD) to specified table to user. But, now, i want to grant all privilege (CRUD) of all tables, views, sp, ... of database to the user. is it possible?regards,

View Replies View Related

How To Grant Permission To User?

Hi,
I newly created one database (using creat database testdb ). After that i created login name and password for that database ( using create login login1 with password = 'pass1'; use testdb; command) and i created user for that login name ( using create user user1 for login login1 command).
Then i connected testdb database using login1. But when i trying to create table in that database, it thrown error. Anyone please tell me that how to assign all privileges to the user user1?

Sathish kumar D

View Replies View Related

Grant Showplan To &&<user&&>

 
I was trying to review some query statistics and received the following message:
 
SHOWPLAN permission denied in database Test
I gave the user permission by the following command:
Grant showplan to user.
I am curious as to how much perfomance does this effect? Is there an alternative?
regards

View Replies View Related

Grant Server Role To A User For A Particular Job

Hello All,

Trying to run a sqlserver stored procedure which requires the user to have the 'System Administrators' server role.

Is there anyway to grant access for this user to this server role by using SQL GRANT command or so.

Thanks,
Kumar.

View Replies View Related

T-SQL - How To Grant Public Access To A DB For A User

I need an example of how to grant access to a SQL user to a DB. For the life of me I can't seem to get my syntax correct. My database name is TEST and my username is LEMME_IN and I want to grant the user "Public" access to the db with db_datareader, db_datawriter database role membership.

Thanks

View Replies View Related

Grant Permissions In All User Databases

Hello together,

can anybody help me. I'm looking for an easy way to grant permissions to a user in all user databases. I already have a script which grants permission to all views and userdefined tables within one database, but since I have to run it in about 100 databases it's still quite timeconsuming.
Is there a way to execute that script in all user databases at once ???

Markus

View Replies View Related

User Without Login : Grant Problem.

Hi to everybody,

I have a permission problems with user create for service.

I created an user  without login in a database. I use this user for service broker activation procedure.So, this user have a certificate to exports in other database.

To generalize activation procedure of many service broker queue I try to use this piece of code :

 

  DECLARE @QueueName nvarchar(MAX)
  DECLARE @queue_id int

    SELECT @queue_id = queue_id FROM sys.dm_broker_activated_tasks
    WHERE spid = @@SPID

    SELECT @QueueName = [name] FROM sys.service_queues
    WHERE object_id = @queue_id




To use this DMV  user need VIEW SERVER STATE grant but this is an user DB and I can't give this grant to user.




How I can do it?

 

Somebody can help me?





Thanks in advance

Luca




 

View Replies View Related

How Do I Grant User To View Folder

We have a custom security working with forms authentication. When we browse to http://servername/reports the UILogon.aspx page comes up, and login with the Admin account is fine we can reach the report manager and see the folders. But when we login with account User1 , which is not an admin account.Login is fine but User1 does not see any folders in report manager. So how do i assign roles to User account when using custom security extension. 

 

chi   

View Replies View Related

Grant User Access To Project

How do I grant a user access to a particular project?  I have set up some reports and want other users to look at them as a template to build their reports and keep getting projectname.rptproj.user is denied.
 
Thanks, Iris

View Replies View Related

How To Grant Permissions To A User In A Different Database

 
I have a larger stored procedure that is running, but I am getting stuck on where I need to grant permissions to a user in a a different database on various functions and stored procedures. For example:

 



Code Snippet
 
use [Database1]
grant exec on [Database2].[dbo].[MyFunction] to bob
 
 

 
returns this error:  Cannot find the user 'bob' , because it does not exist or you do not have permission.
 
However, I know 'bob' exists, plus when I change the use statement to Database2, the line of SQL works correctly.   Given the nature of the overall stored procedure this will be running in, I won't have the ability to just change the use statement. Is it possible to grant permissions to a user on a different database without explicity having the use statement set to a particular database?

Thanks for any advice!
 
-Flea#

View Replies View Related

Grant Insert Access To User

I am build an application that able to update insert delete an entries from my sql server, i create a new account in sql server management studio express so my app can connect to the database thru SQL Server Aurthentication. Delete & update method work well but my insert dont.

I change to the connection string to localhost ( WindowsAurthentication) and it works so i conclude that the problem lies on the sql user access. However I had already ticks everything on object explorer > security > logins > my user properties > Server Roles & User Mapping. What should i do inorder to grant insert/create database access to my sql user? Thanks.

View Replies View Related

How To Grant User Permission To Create Other Users?

There's something I can't quite figure out about user creating

 

The application that I'm currently working on is interacting with DB, therefore every time you use application you need to login as user which is fine. The problem is that certain users should be able to create new users and the new user may even have the same level of permissions as the one that's creating it ( like admin creating another admin acount or some like that).

 

Question is how can I allow users to create these user with giving them as few permissions as possible.

 

If there's is somewhere a code sample on the net I would appreciate the link.

 

 

 

 

View Replies View Related

HOW TO GRANT EXEC ALL THE STORED PROCEDURES TO A NEW USER? ONE BY ONE OR ONE STATEMENT

View Replies View Related

How To Grant Permission To A Specific User To Run SQL Scheduled Jobs?

Hello Everyone,

I have an web application where the users has to run SQL scheduled jobs from the webpage. How to assign permission to a specific user to run specific jobs without making them a member of a Sysadmin role?

Any ideas you all smart people?
Thanks in advance!

Jannat.

View Replies View Related

How To Grant Create Procedure Permission To Database User?

Can somebody tell me without pointing to any other link how to grant Create Procedure permission to DB user.
 

View Replies View Related

Issue On SSRS2005 To Grant Permissions To User Are Insufficient

 
I have a problem to execute report (.rdl) in my web application. it says that "
The permissions granted to user 'SYSTEMAIUSER_SYSTEMA' are insufficient for performing this operation.". Actually am working on two systems which are SYSTEMA and SYSTEMB, SYSTEMA and SYSTEMB are having reportingservices and my web project. when i try to access web application and reporting services (which mapped with local server) from SYSTEMB to SYSTEMA am getting the above error. Please any one help me to come out from this issue.

View Replies View Related

Howto Setup My User In Order To Grant Him The Drop Privilege

Hi. Thru a sproc, I drop & re-create some temp tables.When I call that sproc from the client, though, I cannot drop thetables.I need to allow the user, say "Alex", to drop/create tables (actually,that would be DDL). Which role should "Alex" assume ? How do I do that?I run the following sproc named, say, "CREATE_TABLE" (SNIP):__________________________________________________ __________________Set @StrSQL = 'if exists (select * from dbo.sysobjects where id =object_id(N''[dbo].[' + @TableName + ']'') and OBJECTPROPERTY(id,N''IsUserTable'') = 1) drop table [dbo].[' + @TableName + ']'Exec (@StrSQL)Set @StrSQL = 'CREATE TABLE [dbo].[' + @TableName + '] ([GROUP] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,...........[Stuff] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL) ON [PRIMARY]'Exec (@StrSQL)Set @StrSQL = 'GRANT SELECT , UPDATE , INSERT , DELETE ON [dbo].['+ @TableName + '] TO [Alex]'Exec (@StrSQL)__________________________________________________ __________________As you can see, it is dynamic, because I need to repeat it for many@TableName values - that means, further more, that I will be executingthis in the context of the current user, Alex, and therefore I have togive Alex rights to both executing the sproc and to the tables referredto by the sproc, as specified by @TableName.I created a _TEST sproc which contains only the following:_______________________________________________CREATE PROCEDURE _TEST ASDROP TABLE [dbo].[SomeTable]RETURN_______________________________________________When I execute it from the client, thru ADODB, on user Alex, I get"User does not have permission to execute this operation on tableSomeTable"The table has been created thru "CREATE_TABLE", abovePlease help, I have to finish this tomorrow, and I'm under tons ofpressure.Thanks a lot,Alex.

View Replies View Related

User Without Login : Grant To View Server State Problem

Hi to everybody,

I have a permission problems with user create for service.

I created an user  without login in a database. I use this user for service broker activation procedure.So, this user have a certificate to exports in other database.

To generalize activation procedure of many service broker queue I try to use this piece of code :

 

  DECLARE @QueueName nvarchar(MAX)
  DECLARE @queue_id int

    SELECT @queue_id = queue_id FROM sys.dm_broker_activated_tasks
    WHERE spid = @@SPID

    SELECT @QueueName = [name] FROM sys.service_queues
    WHERE object_id = @queue_id




To use this DMV  user need VIEW SERVER STATE grant but this is an user DB and I can't give this grant to user.




How can I do it?

 

Somebody can help me?





Thanks in advance

Luca

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved