While I was evaluating an AWS Redshift lab on qwikLABS, the lab directed me to connect to Redshift cluster by using JackDB which is a hosted service that can be used as a secure client software to connect to cluster in order to run queries . Thus, you are able to query your database by using a 3rd party client software.
If you are seeking a service like JackDB, all of the plans come with 14-days free trial.
Before adding a data source to JackDB dashboard, make sure that you have already configured the AWS security group which allows the incoming connection that is initiated from JackDB IP’s.
In addition to this, you can undoubtedly use it to connect to Azure SQL service as well. I have added a data source which is hosted on Azure SQL.
Continue reading JackDB – Direct SQL access
In this post, I am going to cover the sudoers in CentOS7. You all probably know that su means super user or substitute user and sudo means “do as su(per user)” :)
If you login to the system as root user, you are allowed to run all of the commands. I will try to perform several tasks as normal user for you to review the results.
Let’s try to run command by using sudo then.
Continue reading Linux – Sudoers
In this blog, I am going to review file and folder permissions which are assigned to user , group and other objects.The very fundamental parameters that are needed to be considered when assigning permissions are User,Group,Others,Read,Write,Execute. In shortly, we can use ugo for user,group,others and rwx for read,write and execute. The table shown below is sufficient to express permissions in octal mode.
Continue reading Linux – Granting permissions
Hey dear readers,
In this post, I am going to review user object creation, group object creation, group membership change tasks. The distribution I have setup is CentOS7.
Firstly, I will create few user objects. The very basic command to achieve this task is to run “useradd user_logon_name” .
As you see, the user is created without a password. That’s why, it can not be used to login to the system. To assign a password to the new user , you can run the passwd command as shown below.
Continue reading Linux – User & Group Basics 2
I am going to review basic user group management tasks such as user creation, group creation, group membership changes, the files where user,group objects are stored. I have a CentOS7 basic installation. Before jumping into hands-on’s, it should be good to remind you about /etc/passwd and /etc/group files.
/etc/passwd file stores user informations created in your linux OS and a sample view of /etc/passwd file is shown below.
Let’s scrutinize the meaning of fields at first.
Continue reading Linux – User & Group Basics 1