I don´t have access to data base

Ramon Quintana

7y898

hi,

I'm trying to get access with "user b" to a Sql Server Data Base whitch it was created by "user a".

I got this error:

I otrher words i mean i cannot access to "1RQ_BPCSQL1" Data Base whitch was created by other person with another Windows session..

Where i have to change the right permittion to be able to use that Data Base??

Thanks.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajeesh Menoth7y ago
Accepted answer
Hi,

Please check the following article.

Reference :

https://blog.sqlauthority.com/2011/12/27/sql-server-target-recovery-time-of-a-database-advance-option-in-sql-server-2012/
+2
Ramon Quintana7y ago
Hi, Amit.

The Problem is just that i can not to open "the Properties command" due to lack of permittion to do that, but i Run SQL SEVER as Administrador and then i can open the whole Data Base and all of her components,

Thank for your support likely..

Cheers to all of u.
0
Amit Kumar7y ago
Hi, you cansolve it very way step by step. They are as given below.Using SQL Server Management Studio To change the target recovery timeIn Object Explorer, connect to an instance of the SQL Server Database Engine, and expand that instance.Right-click the database you want to change, and click the Properties command.In the Database Properties dialog box, click the Options page.In the Recovery panel, in the Target Recovery Time (Seconds) field, specify the number of seconds that you want as the upper-bound on the recovery time for this database.For more details go through the below links:https://docs.microsoft.com/en-us/sql/relational-databases/logs/change-the-target-recovery-time-of-a-database-sql-server?view=sql-server-2017 https://www.google.com/amp/s/blog.sqlauthority.com/2011/12/27/sql-server-target-recovery-time-of-a-database-advance-option-in-sql-server-2012/amp/
0
Mohsin Arif7y ago
hi
you see in folders there is security folder in which all users and permissions are exits
+1