Search Results

Search found 1027 results on 42 pages for 'grant mclean'.

Page 1/42 | 1 2 3 4 5 6 7 8 9 10 11 12  | Next Page >

• SQL SERVER – Difference Between GRANT and WITH GRANT

  - by pinaldave

  This was very interesting question recently asked me to during my session at TechMela Nepal. The question is what is the difference between GRANT and WITH GRANT when giving permissions to user. Let us first see syntax for the same. GRANT: USE master; GRANT VIEW ANY DATABASE TO username; GO WITH GRANT: USE master; GRANT VIEW ANY…

  Read the article

• SQL SERVER Difference Between GRANT and WITH GRANT

  This was very interesting question recently asked me to during my session at TechMela Nepal. The question is what is the difference between GRANT and WITH GRANT when giving permissions to user.Let us first see syntax for the same.GRANT:USE master;GRANTVIEW ANY DATABASETO username;GOWITH GRANT:USE master;GRANTVIEW ANY DATABASETO username…

  Read the article

• Fixing my SQL Directory NTFS ACLS

  - by Shawn Cicoria

  I run my development server by boot to VHD (Windows Server 2008 R2 x64).  In that instance, I also have an attached VHD (I attach via script at boot up time using Task Scheduler).  That VHD I have my SQL instances installed. So, the other day, acting hasty, I chmod my ACLS – wow, what a day after that. So, in order to fix it…

  Read the article

• Grant root access without having grant access with mysql

  - by PJ

  In attempts to learn more about apache and mysql, I've been fiddling with my local environment. Fun times. Of course, this leads to my screwing things up. So, thanks for being there. Recently, I messed up a bit in mysql. I currently don't have a root user, and the users I do have don't have grant access. So, I can create users and all…

  Read the article

• MySQL Privileges required to GRANT EVENT, EXECUTE, LOCK TABLES, and TRIGGER

  - by Brad

  I have an account, user_a, and I would like to grant all available permissions on some_db to user_b. I have tried the following query: GRANT ALTER, ALTER ROUTINE, CREATE, CREATE ROUTINE, CREATE TEMPORARY TABLES, CREATE VIEW, DELETE, DROP, EVENT, EXECUTE, INDEX, INSERT, LOCK TABLES, REFERENCES, SELECT, SHOW…

  Read the article

• MySQL Grant Problem

  - by Joel Dare

  Why might the following grant statement fail to work? grant all on kylie.* to 'kylie'@'localhost' identified by 'foo'; Here's the complete output. $ mysql -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 63 Server version: 5.1.37 Source distribution Type 'help;' or '\h' for help. Type…

  Read the article

• GRANT with database name wildcard in MySQL?

  - by JR Lawhorne

  I want to create a user 'projectA' that has the same permissions to every database named 'projectA_%' I know its possible but MySQL doesn't like my syntax: grant all on 'projectA_%'.* to 'projectA'@'%'; Reference: http://dev.mysql.com/doc/refman/5.1/en/grant.html

  Read the article

• Grant permissions to a set of databases matching a pattern in MysQL 5.0

  - by Xian

  I'm lead to understand that the following grants all proveleges to all databases that name begin with 'xian_', but mysql complains about a syntax error near ''xian_... GRANT ALL PRIVILEGES ON 'xian_%.*' TO xian@'192.168.1.%'; What is the correct syntax? Am I right in thinking that the _ needs escaping to \_ too as it is also a…

  Read the article

• t-SQL grant permission for table drop and create

  - by Melody Friedenthal

  How can I Grant some users permission to drop and create a single table only in the SQL 2005 database accessed by our VB.net 2005 Win app? Some articles suggest Granting Control rights to the table but I cannot make this work. If you think this is teh way to go, can you show me the correct syntax?

  Read the article

• Grant users access to mysql with a dash in the database name

  - by Matt

  Unfortunately, I have a database name with a dash in it. How do I grant access to that database as mysql reports a syntax error. e.g. grant select,insert,update,delete on astpp.* to 'portal'@'localhost' identified by 'Ab7g12Xh35' with grant option; works, but grant select,insert,update,delete on astpp-eth01.* to…

  Read the article

• How to make a GRANT persist for a table that's being dropped and re-created?

  - by Eli Courtwright

  I'm on a fairly new project where we're still modifying the design of our Oracle 11g database tables. As such, we drop and re-create our tables fairly often to make sure that our table creation scripts work as expected whenever we make a change. Our database consists of 2 schemas. One schema has some tables with…

  Read the article

• Grant Ronald and Frank Nimphius Deliver Free advanced ADF training for partners

  - by Grant Ronald

  Calling all Oracle partners.  If you are looking to get the best out of your Oracle ADF investment then you might want to consider the following free ADF training.  Frank Nimphius and I will be delivering a 5 day advanced ADF course for partners in Portugal.  This will cover topics such as task…

  Read the article

• Design – Architecting for Mobile Integration Overview by Grant Ronald

  - by JuergenKress

  This episode: In this episode of ADF Architecture TV Grant Ronald looks at the challenges and some solutions when building ADF services to be consumed by mobile clients. Including versioning APIs, building proxies and facades, and utilizing a service bus. Watch the video here. SOA & BPM Partner…

  Read the article

• MySQL mistake with grant option

  - by John Tate

  I am unsure reading the MySQL documentation if creating a user with the GRANT option will give them the power to create users and grant privileges, or change the privileges of other users databases. I have been creating databases for users like this CREATE DATABASE user; USE user; GRANT ALL PRIVILEGES…

  Read the article

• Grant Ronald - Forms, ADF guru Budapesten!

  - by peter.nagy

  Tudom, késon szólok (blogolok : ), de mégis a lényeg akkor: Grant Ronald lesz a vendégeloadónk az Oracle hazai Technology Forum rendezvényén. Röviden róla: Grant Ronald (Senior Group Product Manager, BSc.) 1989 óta dolgozik az IT iparágban és 1997-ben csatlakozott az Oracle Support…

  Read the article

• Grant’s video warning – backup verification

  Grant takes a humorous (but completely serious) look at why you should be regularly verifying your backups. Get top tips for backup and recovery, and protect yourself when disaster strikes. Watch the video Schedule Azure backupsRed Gate’s Cloud Services makes it…

  Read the article

• Oracle ADF Essentials & ADF training material now on the iPad By Grant Ronald

  - by JuergenKress

  Faster and Simpler Java-based Application Development - Now Free Oracle ADF Essentials is an end-to-end Java EE framework that simplifies application development by providing out-of-the-box infrastructure services and a visual and declarative development experience. Oracle ADF …

  Read the article

• Grant Showplan : MS SQL Server 2005

  SQL version applied to: 2005 Grant Showplan The SHOWPLAN permission only governs who can run the various SET SHOWPLAN statements. There is no impact on performance of this. And with some of the SHOWPLAN statement in effect, the statement(s) is not executed and goes through…

  Read the article

• ADF sessions at UKOUG conference by Grant Ronald

  - by JuergenKress

  For those in the UK, or those who have a few travel dollars left in their budget I just wanted to hi-light a couple of reasons you might want to present to your management as to why you should attend the UKOUG conference this year to get your ADF fill. Firstly, there…

  Read the article

• How do I grant a site's applet an AllPermission privilege?

  - by nahsra

  I'd like to specify certain applets to run with java.security.AllPermission on my computer (for debugging and security testing). However, I don't want to enable all applets that I run to have this permission. So, editing my user Java policy file (which I have ensured is…

  Read the article

• Learn Advanced ADF online – for free by Grant Ronald

  - by JuergenKress

  DF knowledge is key for any BPM implementation! The second part of the advanced ADF online eCourse is Live now! This covers the advanced topics of region and region interaction as well as getting down and dirty with some of the layout features of ADF Faces, skinning…

  Read the article

• Howt to grant network access to LocalSystem account?

  - by Ian Boyd

  How do you grant access to network resources of the LocalSystem (NT AUTHORITY\SYSTEM) account? When accessing the network, the LocalSystem account acts as the computer on the network: ...and acts as the computer on the network. Or to say the same thing again:…

  Read the article

• Free ADF Training Event in the UK

  - by Grant Ronald

  At the UKOUG conference back in December, at the Tools Roundtable session someone told me that they hadn't chosen Oracle ADF as their development environement for their future projects.  When I asked why, the response I got was "no one told us about it".  I…

  Read the article

• How to grant "select" on more than one table in MySQL?

  - by user360145

  i want to do something like grant select on arpg.t_account,arpg.t_char to peeker@'localhost'; but fails, is there a way to do so?

  Read the article

• How to grant write permissions in Samba?

  - by Eric Fossum

  I'm having trouble with read/write permissions on my Samba server, how do I fix my smb.conf and file permissions to have a more unified access? smb.conf [global] workgroup = workgroup netbios name = LnxNAS server string = %h wins support = no dns proxy = no…

  Read the article

1 2 3 4 5 6 7 8 9 10 11 12  | Next Page >