Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







User Does Not Have Permission To Perform This Action.


I have been using Beta 2 with Visual Web Developer and SQL express for a few months now and everything was working fine until today.I am trying to connect to the ASPNETDB.MDF file located in my website's App_Data folder, but each time I get the error "User does not have permission to perform this action."I have set up all of the correct permissions on the file.  Since I am using IIS 6.0, I have given NETWORK SERVICE read and write permissions.This is really strange because I did not have this problem before.  Could a new Windows Update have caused this problem???  That is the only thing I can think of that would have possibly changed anything.Please help!


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
User Does Not Have Permission To Perform This Action.?
I am trying to use a query analyzer to perform a task and I keep getting this message....how do I get around this?

View Replies !   View Related
The User Does Not Have Permission To Perform This Action.
hi,I am getting the following error while trying to add a remote server.The user does not have permission to perform this action.The command i used is:exec sp_addlinkedserver 'remote_server_name'What is the solution?Regards,Kalaivanan.

View Replies !   View Related
The User Does Not Have Permission To Perform This Action
Hi All

 

I kind of hit the wall with this message.

Here is what I do:

select * from sys.dm_db_index_physical_stats(24,null,null, null, null)

My server is 64 bit 2005, sp2.

 

That's the message I get.

I am loging int as Administrator.

Does anybody know what needs to be done?

View Replies !   View Related
[SqlException (0x80131904): User Does Not Have Permission To Perform This Action.]
Folks, This is driving me nuts.  I posted the other day on a related issue, which I belive turned out to be a file permission.  I am trying to test my asp.net site under IIS before deploying it.  I am now getting the above message which breaks on the opening page on opening a connection to the sql server database.  I have permissions set on the database for MachineNameASPNET and NT AUTHORITYNETWORK SERVICE as Ken Tucker suggested. Still getting the message.  This certainly looks like a sqlserver permission issue but I am at a loss as to how to grant IIS or the specific  web app permission to access the database. Any assistance is truely appreciated.  I have spent way to many hours on this.  If you don't have the answer but can suggest a resource where I can research it that would help also. Thanks 

View Replies !   View Related
SQL Server Express Not Working: User Does Not Have Permission To Perform This Action.
I've built this prototype web app in asp.net 2.0

 

it uses a sql server express database.

 

It uses the database to populate a grid control.

 

It works when I run it from my pc when I

1). run it in debug mode.

2) right click a page in the vs2005 IDE and browse

3). browse a page from the IIS snap in

 

it doesn't work from other peoples PC on our intranet say if someone types:

http://xxx.xxx.xx.xx/mywebapp/default.aspx because I get this result:

 
Server Error in '/FocusII_Website' Application.


User does not have permission to perform this action. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: User does not have permission to perform this action.

Source Error:





Line 82:
Line 83: SqlDataAdapter da = new SqlDataAdapter(sql, ConfigurationManager.ConnectionStrings["sqlExpress"].ToString());
Line 84: da.Fill(ds);
Line 85: RadGrid1.DataSource = ds;
Line 86: RadGrid1.DataBind();
Source File: c:InetpubwwwrootFocusII_WebsiteUnitGridPrototype.aspx.cs    Line: 84

Stack Trace:





[SqlException (0x80131904): User does not have permission to perform this action.]
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +437
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +86
UnitGridPrototype.Page_Load(Object sender, EventArgs e) in c:InetpubwwwrootFocusII_WebsiteUnitGridPrototype.aspx.cs:84
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061











Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

 

Impersonation is set to TRUE

 

Anonymous access is checked.

Integrated Windows Authentication is checked..

 

aspnet, iusr accounts have full privs on the data directory,,,,,

 

I'm at a loss..

 

 

 

View Replies !   View Related
Visual Studio - Sql Express, &"user Does Not Have Permission To Perform This Action&"
winxp pro, vs2005, sqlexpressIm building an application that uses a sqlexpress database and apparently something has changed, but im not sure what.  When I try to expand the node for my sqlexpress database within visual studio, i get an error "user does not have permissions to perform this action".  I can connect with sqlexpress management studio.  What should I check ?My connection string looks like so: data source=.SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|mytestnetdb.mdf;User Instance=true 

View Replies !   View Related
&"User Does Not Have Permission To Perform This Action.&" Problem
hey people having a nightmare getting asp.net 2.0 to work with sql server 2005 express, bit of a newbie with it. trying to display a table from my sql database and every time i run the aspx table im getting this error.  User does not have permission to perform this action.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: User does not have permission to perform this action.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): User does not have permission to perform this action.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734995
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +130
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83
System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1770
System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17
System.Web.UI.WebControls.DataBoundControl.PerformSelect() +149
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70
System.Web.UI.WebControls.GridView.DataBind() +4
System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82
System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69
System.Web.UI.Control.EnsureChildControls() +87
System.Web.UI.Control.PreRenderRecursiveInternal() +41
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360 keep getting the user permission error, even though it says on the management console that i have access to the database any ideas?  rob    

View Replies !   View Related
Error Creating First SQL Express Database Via VWD 2005 Express: &&"User Does Not Have Permission To Perform This Action&&"
I get an error dialog when I try to create a new SQL database, both via the Add New Item dialog and the property wizard of a new SqlDataSource control.  The error is:


Local Database File:

User does not have permission to perform this action.

I've searched for help with this. 

I ensured the App_Data folder exists and I added the local ASP.NET account to the group that have R/W access to it (although the RO flag is in an unchangeable tri-state on the folder). 
The SQL Server Express error log is clean and indicates full functionality. 
Everything is running locally. 
No VWD installation errors.

Any ideas?

Thank you!

View Replies !   View Related
Error:User Does Not Have Permission To Perfor This Action.
I just installled the Visual web developer - express addition. When I try to add aSQL database to my project it gives the following error - "User does not have permission to perfor this action" . Can someone please help?

View Replies !   View Related
How To Perform A Action On List Of Empcode
Dear all,
I am using sql server 2005.
Let me explain the scenario : I am making request system where one request goes to immidiate boss and its immidiate boss till the contry head and even one has right to approve or reject the request. Once its approve from one level it goes to other level but now problem is if some one in the hierarchy does not responds.
My table staructure is
RequestnoRequestempRequestdateSuperierempExpirydatestatus
0001 Em486 21-04-2008 Em604 23-04-2008 Hold

To do the same I am trying to schedule a job which run one sp where I am searching all the superieremp whose status is hold and expirydate is today date. Now problem is when there is multiple record as against each indivual I have to insert the record in the same manner

Please suggest some ideas or any other idea please suggest

Thank you.

View Replies !   View Related
SQL To Get The Latest Instance Of User Action
Hi

Im in a bit of a pickle due to a large amount of data in a table and the query Im running is taking a very long time, so Id like to get some advice from the guys here to see if it can be done another way.

Ok, so heres the background. I have a table, see desc below, that contains transaction data for a number of users. Each user may have more than one transaction. In each row the SEQUENCENUMBER column is populated with a timestamp for the transaction, so I was using this to get the latest. However there are over 1 million rows in the table and the query below has taken over 12 hours so far to run. Has anyone any ideas on how I can make life a little easier for myself here?

SQL Query

Code:


select user,recipient,sequencenumber from trans_database where user IN (select distinct(user) from trans_database)
order by sequencenumber desc limit 1;



Table Layout

Code:


ID int(10) unsigned (NULL) NO PRI (NULL) auto_increment select,insert,update,references
RECIPIENT varchar(5) latin1_swedish_ci NO select,insert,update,references
DONOR varchar(5) latin1_swedish_ci NO select,insert,update,references
USER varchar(20) latin1_swedish_ci NO select,insert,update,references
UPDATETYPE varchar(10) latin1_swedish_ci NO select,insert,update,references
REPFLAG varchar(1) latin1_swedish_ci NO select,insert,update,references
OPFIELD varchar(20) latin1_swedish_ci NO select,insert,update,references
SEQUENCENUMBER varchar(18) latin1_swedish_ci NO select,insert,update,references
REQUESTDTS varchar(20) latin1_swedish_ci NO select,insert,update,references
PROCESSED varchar(1) latin1_swedish_ci YES (NULL) select,insert,update,references

View Replies !   View Related
Initiating SSIS Job From A User Action On The Web
Hello All:
I have a web-based utility that enables users to enter data.  I have created several SSIS packages that run on a regular basis that act on the data being collected.  While the packages run on a set schedule now I would like to provide users the ability to trigger a package on an as-needed basis as well.  The question is how do I do it?
 
I do not know VB.net, and believe that the web app has been coded using ASP.net.  I am looking for some high-level pointers to go about my task.  Any links to some articles would also be appreciated.
 
Thank you!

View Replies !   View Related
Passing Parameter To Subreport Based On User Action.
I have a main report and a subreport. Subreport is not at row level but is at report level. The sub report has a parameter that needs to be passed from mainreport. However, the subreport's parameter should be set and the subreport should be refreshed when the user clicks on a row in mainreport. Can I use drill-through / navigation feature  in any way to build this functionality?
 
Any help will be most appreciated.

View Replies !   View Related
User Permission
Hi,

I grant read/update/insert permission on the speicific columns of the table on the users. I want to write the T-SQL to retrieve what permission/column permission does the user have.

View Replies !   View Related
Set Up User Permission
 

Hi,
 
I am new to reporting service. I set up a couple reports and deployed them to Report Manager. I then add my colleague's Windows user account to the report folder so she can view the reports. When she tried she got Login failed error. I have to go into the SQL database and manually add her account into the Login and assign permission to her for each database or stored procedure involved. Then she can view the reports. We do want to control who can view what reports and later hopefully who can view which part of a report. But do I have to manually give permission to each user account/or group in the SQL server? There got to be a better way to do this I feel. Can we use just one account to talk to the database and let what we set in report manager control who can view what? Thank you very much for your help in advance.

View Replies !   View Related
User Permission List
Hi, Does anyone has a script to get user permissions on all tables?
Thanks

View Replies !   View Related
Restoring User Permission
I have a nightly job that restores a production database to a reporting server. I have some report- related stored procedures
that need to run on the reporting server once the database is restored. However, during the restore, the permissions for the
reporting stored procs get deleted and replaced with the production permissions, which are useless in this case.

Is there a script or system stored procedure I can schedule to run after the nightly restore that will also restore user
permissions? Thanks, Frank.

View Replies !   View Related
User Permission Needed
Hi all,

I need to run a query that would return all users with sa privileges at a server level. Sysusers has the db users for each individual databaase. But I need to list all sa users and the databases they have rights to. Looks like I may need a cursor...not sure. If any of you can help me build this query, I would really appreciate it. Thanks.

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
User Does Not Have Permission (error 15247)
Hi,I have installed sql server 2005 express on a Windows xp system with windows authentification. I did this with my administrator account (dan). When i start sql server management studio, i see: user name: myserverdan .Now i want to create a new login, so i rightclick on 'logins' in 'Security' of 'Database'. I take an existing windows-account, but when i click on OK, i get the error: user does not have permission to perform this action (error 15247).I also tried to delete a login, but same error.Any help would be appreciatedT.

View Replies !   View Related
Give Permission For One User To All Tables
Could any boby help me what is quickest way to do, I need to give a select permission to one user to all the tables. We have 20 databases.

Thanks.

View Replies !   View Related
Login/User Permission For App Developers
Hello Everyone,
I need your input. When, if ever, should programmers be given the 'sa' login. The reason that I ask is because a group of three developers have approached me asking for the 'sa' login so they could write stored procedures and do some database level tasks. I am relatively new to data admin and I am under the opinion that I should probably just alias their login to 'dbo' on the one database that they are developing their app for.

What do you guys think about this.

Thanks in Advance,
Terry

View Replies !   View Related
Script To Generated The User And Permission
Here is the simple script, which generated the user and user permission and can be transferred to another database. I think it may useful for new DBA. I just wrote it 2 days ago.

-----------------------------------------------------------------



declare @login varchar(20),
@db_user varchar(20),
@role varchar(30),
@role_mem varchar(30)

print 'USE '+ db_name()
print '-------------------------------------------------------------'
print '--Granting current DB access'
print '-------------------------------------------------------------'
declare add_user cursor for
select b.name as 'login', a.name as 'db_user' from sysusers as a inner join master..syslogins as b
on a.sid = b.sid and b.name <> 'sa' order by a.name,b.name
open add_user
fetch next from add_user
into @login, @db_user
while @@fetch_status = 0
begin
print 'exec sp_grantdbaccess '+''''+@login+''''+','+''''+@db_user+''''
fetch next from add_user
into @login, @db_user
end
close add_user
deallocate add_user
print '-------------------------------------------------------------'
print'--Adding role'
print '-------------------------------------------------------------'
---------add role
declare add_role cursor for
select name from sysusers where issqlrole =1 and gid <> 0
open add_role
fetch next from add_role
into @role
while @@fetch_status = 0
begin
print 'exec sp_addrole '+''''+@role+''''
fetch next from add_role into @role
end
close add_role
deallocate add_role
----------add role members
print '-------------------------------------------------------------'
print '--Adding role members'
print '-------------------------------------------------------------'
declare add_role_member cursor for
select g.name as 'role',u.name as 'name'from sysusers u, sysusers g, sysmembers m
where g.uid = m.groupuid and g.issqlrole = 1 and u.uid = m.memberuid and u.name <> 'dbo' order by g.name,u.name
open add_role_member
fetch next from add_role_member
into @role_mem,@db_user
while @@fetch_status = 0
begin
print 'exec sp_addrolemember '+''''+@role_mem+''''+','+''''+@db_user+''''
fetch next from add_role_member
into @role_mem, @db_user
end
close add_role_member
deallocate add_role_member




Sanjeev shrestha

View Replies !   View Related
Permission For Linked Server User
Dear,
 
What minimum permission do i need to grant to a Remote Login to  create a linked server.
 
Regards
Sufian

View Replies !   View Related
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
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
Will User's Permission Be Overriden By Database Role?
in SQL server 2005, Database User's permission will be overriden by the database Role's permission or ottherwise? For example, a userA is owner of table AA so it has all permisions on table AA but the user is a member of GroupB but group B has no permission to access to Table AA. What happen on User A?. has it permission to access to table BB or not? How can I find document or example about this?
Please help me, thanks so much

View Replies !   View Related
Creating User And Giving Permission To All Databases
 

Hi,
 
Any body please give me some TSQL Stored procedure for
 
 creating an SQL user and to give db access permission to all the databases available on a the server.
 
Mujeeb

View Replies !   View Related
Cannot Add Select User Permission For A Person On A Table
 

Hello,
 
I am trying to grant solely the SELECT privilige to a particular user and to a particular database.I am using Sql server management studio express to do this and SQL Server 2005.
 
I have created a new login and set the server roles to public, then on the user mapping page, I have checked the box next to the table I wish the user to access and have selected the database membership role - public.
Next, On the Table Properties, I have added the user on the Permissions Page and Selected "Select" under the grant column
 
When I click on effective permissions, the select command does not show and when I try to login with that user, the table does not display.
 
What I am doing wrong?
 
Thanks
 

View Replies !   View Related
How To Give Permission To This User To Connect To My Database???
I am using Microsoft Visual Web Developer 2005
 
Here are the steps I used to create my database
 
Tools -> connect to database -> Select datasourse - Microsoft SQL Server (SqlClient) -> Server name - comp4_8SQLExpress -> Log on to the server €“ Use Windows Authentication -> Connect to a database -> Select or enter a database name €“ MyDataBase
 
comp4_8 - is the name of my computer. I am using Windows XP Professional SP2. Login as administrator without password.
 
Now about the problem I have. On local machine everything is great! But I hosted my website and got this error. The question is how to give permission to this user to connect to my database.
Cannot open database "MyDataBase" requested by the login. The login failed.
Login failed for user 'ANGELINAASPNET'.

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
List Of Stored Procedures With Permission For Executing For User
I have user XY in SQL 05. I would like to find all stored procedures, where user XY has permission for executing. Is there any way to find it than look in every stored procedure?
 
Thanks for tips

View Replies !   View Related
Getting Problem In Giving Database Permission To Group User
hi ,

I am getting some problem in using group in sql server login.

i have two NT groups in windows.i) developer and tester

I added a user Lalit in both gruop. I want to give db_owner permission on  a particular database(Employee)  to developer group and data_denyreader and deny_writer on same database(Employee) to tester group.

 

Now when i logging in to sql server using Lalit(windows authentication)  iam not able to access the database(Employee).

 

Now my concern is that Lalit should have full access to the employee database when entered as developer user and limited access to employee database when entered as tester user.

 

how can i achieve this set up????

 

Please do help.

 Thanks a lot in advance !!!!!!!!!!!!!!!!!!

 

View Replies !   View Related
The User 'sa' Does Not Have Permission To Register Endpoint 'sql_endpoint' On The Specified URL. Please Ensure The URL Refers T
I am trying to create an endpoint with sa

 

CREATE ENDPOINT sql_endpoint

STATE = STARTED

AS HTTP(

PATH = '/sql',

AUTHENTICATION = (INTEGRATED ),

PORTS = ( CLEAR ),

SITE = 'SERVER'

)

FOR SOAP (

WEBMETHOD 'GetSqlInfo'

(name='master.dbo.xp_msver',

SCHEMA=STANDARD ),

WEBMETHOD 'DayAsNumber'

(name='master.sys.fn_MSdayasnumber'),

WSDL = DEFAULT,

SCHEMA = STANDARD,

DATABASE = 'master',

NAMESPACE = 'http://tempUri.org/'

);

GO

View Replies !   View Related
How To Assign Execute Permission To Batch Of Stored Procs To A User/role
Just wondering if anyone knows of a useful command to assign execute permissions to a batch of stored procs to a user/role.  I've got too many stored procs to manually go thru the steps of browsing for them and scrolling thru each one and clicking "execute" for each one. 
 
Also, would like to know if its possible to update a batch of stored procs that begin with a prefix like "spSomething_".
 
Any info would be helpful! TIA.
 

View Replies !   View Related
What Permission I Need To Grant To A User If He Need To Read Or Write A Link Server Tables
hello,

 

What role or system privilege do I need to grant to a user if he need to read  the data from a table which is in a link server object? where I can find the document about these commands.

 

Thanks

View Replies !   View Related
Cannot Debug Stored Procedures Because The SQL Server Database Is Not Setup Correctly Or User Does Not Have Permission To Execute Master.sp_sdidebug.
Hello All,I tried to set the access permissions for debugging stored procedure by reading the articlehttp://msdn2.microsoft.com/en-us/library/w1bhybwz(VS.80).aspxandhttp://technet.microsoft.com/en-us/library/ms164014.aspxI have tried to add the role to sysaminas follows1)SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_NAME = 'sp_sdidebug'(to find the sp)Error:--The stored procedure not found2)sp_addsrvrolemember 'Developmentswati.jain', 'sysadmin' though this is executed successfuly . Error is still persisting 
Cannot debug stored procedures because the SQL Server database is not setup correctly or user does not have permission to execute master.sp_sdidebug.

View Replies !   View Related
User On Trusted Domain Does Have Permission To Access Linked Server On AD Deployed In Another Domain
Hi,
We have the  followoing:

-A "master domain" AD, a  "sub domain" AD, a trust relationship between the two (sub trust master)
-A sql server 2005 on a win server 2003 in "sub domain" AD
-A linked server to "sub domain" AD
-A linked server login using  a "sub domain" admin acccount
-A view to this linked server
-A grant on masterDomain/Domain Users to the database  
-A grant on subDomain/Domain Users to the database   
-We want all connections done through "Windows Authentication" not "Database Authentication".
 
Queries on the view work fine using "sub domain" user accounts.
Queries on the view fail using "master domain" user accounts (including master domain admin accounts)


"Msg 7399, Level 16, State 1, Line 1

The OLE DB provider "ADsDSOObject" for linked server "ADSI" reported an error. The provider indicates that the user did not have the permission to perform the operation."
 
All connections are done through "Windows Authentication" not "Database Authentication".
 
Can we establish cross domain connectivity with "Windows Authentication" ?
 
 
Below are details of the implementation:  
 
SELECT     TOP (100) PERCENT *
FROM         OPENQUERY(ADSI,
                      'SELECT displayname, givenName, sn, cn (etc...)
    FROM ''LDAP://OU=PEOPLE,DC=subDomain,DC=com''
    WHERE objectCategory = ''Person'' AND objectClass = ''user'' ')

EXEC sp_addlinkedsrvlogin @rmtsrvname ='ADSI', @useself='false',
@rmtuser='subDomainAdminAccnt', @rmtpassword='sunDomainAdminAccntPassword';
 
In SQL Server Mngt Studio in Server Objects/Linked Servers/Providers/ ADSI properties security tab I have:

"connections will: <be made using this security context> Remote login:'subDomainAdminAccnt' With password: 'subDomainAdminAccntPassword'
 
Error:
Msg 7399, Level 16, State 1, Line 1

The OLE DB provider "ADsDSOObject" for linked server "ADSI" reported an error. The provider indicates that the user did not have the permission to perform the operation.

Msg 7320, Level 16, State 2, Line 1

Cannot execute the query "SELECT displayname, givenName, sn, cn

FROM 'LDAP://OU=PEOPLE,DC=subDomain,DC=com'

WHERE

objectCategory = 'Person'

AND objectClass = 'user'

" against OLE DB provider "ADsDSOObject" for linked server "ADSI".

View Replies !   View Related
Does SSIS Database Copy Overwrite Existing User Permission To That Database?
Hi guys,
 
I've been assigned the task of setting up access to our SQL Server 2005 box. A consultant developing for us has accessing to 2 databases and I've set this up fine. It appears however that one of these databases is re-copied over to the server every night to keep data reasonably current.
 
I'm not interesting in changing this method as I'm not the maintainer (as yet).
 
Basically I would like to know if I've setup access to this database (it works fine), when the database is updated (with an SSIS package) the account seems to get deleted. Do the original permissions from the source database overwrite those of its destination?
 
Cheers

View Replies !   View Related
SQL Server - Permission Issues : Execute Permission Denied On Object 'SprocName'
I have an application that uses Integrated Windows authentication. My Web.config looks like below
<add key="dbconnection" value=" server=XXX;Initial Catalog=XXX;persist security info=False;Integrated Security=SSPI;Pooling=true" />
When users try to access my application, they get the below error:
Execute permission denied on object 'SprocName', database 'DBNAME',Owner,'dbo'
The Only way I  could get rid off the error is if I set DBO permissions for the user group on the databse.
Can someone suggest how to set up a security group with the ‘necessary’ permissions on SQL SERVER (ie read,write execute Sproc etc) and not too many extra ones, like DBO.
Thanks,
 

View Replies !   View Related
Getting Permission For User &"sa&" On SQL Server Express 2005
I originally installed SQL Server Express 2005 on my computer using Windows Authentication mode, and discovered when I tried to add another user/login that I didn't have permission to do so. This is rather odd as the windows account that I installed SQL server with is the system admin for the computer.

I have successfully changed the login mode to mixed, and have tried to login in as "sa", but it appears that "sa" was given some sort of password (did SQL server automatically generate one?), and I don't know what it is. When I go into command prompt and try to change the password, it says that it cannot alter the login 'sa' because it does not exist or I do not have permission (i'm pretty sure it's the later, as 'sa' shows up on the list of logins in SQL server express).

I'm so stuck! Please help!

View Replies !   View Related
Granting Permission To A Database User To Alter Database Role
I  want a database user to be able to alter login, database user and database role from my application. so, i assigned that user to sccurityadmin server role, db_accessadmin and db_securityadmin database roles....By now, the user can add or remove login and database user. However, the user cannot add or remove any database role membership. What am I missing here?? What should I do so that the user can create, and alter database roles in the database??

View Replies !   View Related
Insert Permission Denied After Granting Permission
 

SQL Server 2005 anomoly?
In SQL Server Management Studio I granted specific permissions to user "A" to do Select, Insert, Update, Delete on Table "B"  -  
When I logged on as User "A" and attempted the Insert imto table "B" I got the following error:
"Insert Permission Denied on Table B, Database C, Schema dbo"
Is this a problem with the dbo schema? 
 
Then I went back and created a stored proccedure "D" with the exact same Insert statement inside the procedure. I granted User "A" execute permission on the stored procedure "D".
I then logged on as User A and executed Stored Procedure "D". No Problem -  stored procedure executed fine with the Insert.
I attempted the Insert statement again - straight SQL - as User "A" and got the same error as above ("Insert Permission Denied.....")
Strange behavior -  cannot do a SQL. Insert even though user has permissions but can execute a store procedure with the same Insert statement.
What gives?
 
 
 

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved