Microsoft Azure SQL Server Read Only User Creation Deletion

Hi folks,

Today I will explain, how you can easily manage the readonly (view) users in Azure Microsoft SQL Server

Procedure

In Azure SQL Server

CREATE LOGIN [testuser] WITH PASSWORD = 'random_p@$$w0rd';

For master and each DB

Note: You must create the user in master db before creating in other databases

CREATE USER [testuser] FOR LOGIN [testuser]   
    WITH DEFAULT_SCHEMA = [dbo];  
GO

Grant Connect permission

GRANT CONNECT TO [testuser]
GO

Give datareader role to read (view) only

ALTER ROLE db_datareader ADD MEMBER [testuser]
GO

Drop user in DB

DROP USER [testuser]

GO

Drop user in Azure SQL

DROP LOGIN [testuser];
GO

Please send your comments and feedback to psrdotcom@gmail.com

Android Screencast Configuration Install in Ubuntu

Hi all,

Today, I am going to show you how to show the android screen on your Ubuntu.

Procedure

• Download the androidscreencast from the official link
• http://androidscreencast.googlecode.com/svn/trunk/AndroidScreencast/dist/androidscreencast.jnlp
• Just by running the jnlp, you won't be able to see the screen
• Java has security restictions
• Now we have to manually add Android screencast url to be allowed in Java Security in Ubuntu
• Go to jre folder
• Example: /usr/lib/jvm/oracle-(8/7)-java/jre/bin/
• Run the following command
• $ ./ControlPanel
• Select "Security Tab"
• Click on "Add" button
• Enter the following http address
• http://androidscreencast.googlecode.com

References

https://code.google.com/p/androidscreencast

Please send your comments and feedback to psrdotcom@gmail.com

Android insufficient permissions for device

Hi Friends,

I was having an issue when connected my friend's Micromax Doodle to my Ubuntu with the following error
"insufficient permissions for device"

Resolution

1. Open Terminal
2. Kill the server by typing the following command
• $ adb kill-server
3. Now, start the server
• $ adb start-server
4. On your device, a pop-up might come asking for granting the permission
5. Click on "Yes" for approving the access
6. Now, check your device status with the following command
• adb devices
7. With the above command, you should be able to see devive IMEI and device name

Enjoy the Ubuntu and Android combination :)

Please send your comments and feedback to psrdotcom@gmail.com